Convert DateTime to UTC

[jdemmi]

Do any of you have any tips, tricks or suggestions for converting a datetime field into UTC format?

I'm stuck with CR 8.5 in this case (old app with embedded reports).

Thanks in advance.

-- Jason
"It's Just Ones and Zeros

 

[lbass]

If you mean you want to shift the time zone, then I think in CR 8.5 you would have to use the dateadd function, and hardcode the difference in hours. If you are trying to standardize for data from multiple time zones, use a formula for the second argument (number of hours) based on location.

-LB

 

[DataDog]

And if you're using multiple time zones, be careful about daylight savings time. Here in the U.S. Central Time Zone, we're -6 Hrs from Zulu time most of the year then -5 Hrs Zulu during Daylight savings time. Then.... You have Arizona and Hawaii (and formaly Indiana) that doesn't go on Daylight Savings Time.....

DataDog
If God wanted us to count in Hexadecimal, then why did he only give us A fingers?

 

[IdoMillet]

At least one of the 3rd-party user function libraries (UFLs) listed at

http://www.kenhamady.com/bookmarks.html

provides time zone functions that automatically take into account Daylight Savings rules.

hth,
- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[DataDog]

So how does it handle Arizona (which is only a portion of Mountain Time Zone) that is GMT-07:00 all year while the rest of the Time Zone goes to GMT-06:00 during the summer?
Also, does the whole world go on/off daylight savings time on the same spring/fall days?

DataDog
If God wanted us to count in Hexadecimal, then why did he only give us A fingers?