Eastern Date/time to Pacific Date/Time 1

[rhoneyfi]

Hello,
I need help with a Crystal Report date/time formula. All my records I have are in Eastern date/time format and I need to convert them to Pacific Date/time. Note: A formula that goes sometime like "hours - 3" will not work.
Example: Eastern time is : 1/20/04 2:00AM should be converted to a Pacific Time of 1/19/04 11:00PM.

Thanks for any help!

 

[vidru]

How about:

DateAdd("h", -3, {Table.Field})

-dave

 

[MJRBIM]

Vidru's suggestion will work is you are not a 24/7 operation.

However, remember that on the twice-yearly change of Daylight savings time - the time difference Eastern to Pacific can be 2 or 4 hours for a short period of time.

If you don't have post-midnight transactions on a Saturday night/Sunday morning - then you can ignore this post.

 

[rhoneyfi]

Cool...works perfectly. Thanks!

 

[synapsevampire]

There are other ways to approach this as well, speaking to timezones in general.

For more sophisticated requirements, look at Ido Millet's product:

http://www.milletsoftware.com/CUT_Light.htm

It's first rate stuff and handles time conversions for all timezones.

Note that newer Oracle databases (I believe ver 9 and above) have a timestamp with timezone data type which has some supporting functions for conversion, so that's a good thing to remember as well.

-k