Nicole McDaniels
asked on
Convert Mountain Time to GMT
I have a formula that converts mountain to PST but how would I rewrite this to convert it to GMT? I can't understand what the "480" in the formula is doing.
(ShiftDateTime(DateTimeVal ue (datadate,datatime), printTimeZone,"Pacific Standard Time,480,Pacific Daylight Time,-60"))
(ShiftDateTime(DateTimeVal
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The other value compensates for Daylight Saving Time, and offsets the calculation by an hour. You don't need to do anything with that number.
ASKER
After I installed the report on the server, the date/time wasn't quite right. After playing around with it, I finally got the right date in GMT by using the following formula.
(ShiftDateTime(DateTimeVal ue (datadate,datatime), printTimeZone,"GMT,0"))
(ShiftDateTime(DateTimeVal
That would give you the time at GMT/UTC, yes, and re-reading the question I see that's what you were after! I'm so sorry - I read this as if you were trying to convert to Mountain Time for some reason.
ASKER
(ShiftDateTime(DateTimeVal