Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Convert DateTime to UTC

Status
Not open for further replies.

jdemmi

MIS
Jun 6, 2001
1,106
US
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
 
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
 
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 [pc2]
If God wanted us to count in Hexadecimal, then why did he only give us A fingers?
 
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 [pc2]
If God wanted us to count in Hexadecimal, then why did he only give us A fingers?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top