GMT Calculation

[crhockey]

Hi,

Does anyone know a calculation for a time/date stamp modification field in GMT?

Thanks

[MarkWilson]

Try this formula. Change the "adjGMT" variable to your local region adjustment or to use a field value.

Let(

adjGMT = "-6:00:00" ;

Timestamp( GetAsDate( TimeStamp_m ) ; GetAsTime( TimeStamp_m ) + GetAsTime( adjGMT ) )

)

[crhockey]

Thanks Mark,

Any idea on how to do this while taking into account the changes in daylight savings time?

Also, any idea on how to also do this on MySQL?

Thanks,

Jack

[MarkWilson]

Add a date test. If the time stamp date is greater than the second Sunday in March and less than the first Sunday in November, most areas of North America, subtract one more hour from the GMT.

I am not familiar with MySQL.