Adding hours to the timezone()

[jaswanthchitra9]

Hello Everyone,

I have a date-time field in the format MM-DD-YYYY hh:mm:ss. I need to substract (-5) hours to this field. currently the time is in GMT(). How can I implement this? below script i'm using but unable to get result can anyone help on this.

ConvertToLocalTime(converttolocaltime([Close Date Time],'GMT-05:00',1), 'Eastern Time (US & Canada)',-5) as [Closed_date_EST],

Thanks!

[justISO · Accepted solution]

Hi, you can just subtract 5 hours with

timestamp([Close Date Time] - 5/24)

or adjust 'timezone' with

ConvertToLocalTime([Close Date Time], 'Eastern Time (US & Canada)')

or

ConvertToLocalTime([Close Date Time], 'GMT-05:00')