GMT to EST time change in query.

[absolut]

I am pulling in data from a database the field is called "CTIME" in the following format 9/27/2004 4:11:21 PM, this time is in GMT. I need in the simple query process to change this to EST which needs to change the date as well if the difference puts it to the prior day.

Any suggestions. Thanks in advance.

 

[Norie]

Try using the DateAdd function.

ESTTIME:DateAdd("h", -6, [CTIME])

By the way I'm just guessing 6, change that as needed.

 

[absolut]

Where does this line go?

I tried it in the criteria line in the design view and got this error The expression you entered has an invalid .(dot) or ! operator or invalid parentheses.

 

[Norie]

It goes in the first line where you would normally put the field.

When you run the query you should see an extra field called ESTTIME.

Do you actually want to update the value in the table?

 

[absolut]

That worked perfect. I am actually changing the value in the final linking result table.

Thank you for saving me countless hours.