Convert GMT to EST

[Montana751]

My database holds the DateTime value as GMT. I need to subtract 5 hours to get EST. I tried taking the date field and minus 5, but thats not working. Need to keep in mind that subtractiing 5 hours could return previous date, so there has got to be more than subtracting hours.

 

[Montana751]

Figured it out, you have to use the DateAdd function

DateAdd ("h",-5,{SCHEDULEDJOB.LASTEND} )

However, if you want to get all timezones, then the -5 should be replaced with a formula that identifies your current timezone and adds/subtracts from the GMT appropriately.

 

[IdoMillet]

You may need to take care of the effect of Daylight Savings Time (DST)...

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[synapsevampire]

Montana: As Ido points out, you don't allow for timezone changes.

And of course it's different now, and may change again in the future.

Anyway, Ido has a product which handles it for you, your approach works fine for one timezone, if you also add in a date range check and adjust the time accordingly.

-k