Set All Dates to GMT

[Kelly Beard]

I have a global user base and I want all release tickets to have a date and time that appear in GMT.

I am close with the following:

addTimeSkippingWeekends({Release Date}, (hour({Release Date},Etc/GMT) - hour({Release Date},SERVER_LOCAL))*{HOUR}, LOCAL,{SATURDAY},{SATURDAY})

My only issue is that if the GMT is on a different Day than the local time. The hour of the day is correct, but the Date is off by one day.

Any help or guidance here is appreciated.

[Fidel Castro Armario]

Hi @jheitman1,

If you only want to get field Release Date represented in GMT timezone, then you can use "Copy a parsed text to a field" post-function with the following configuration:

• Target field: A text field called "Release Date (GMT)", for example.
• Parsing mode: advanced
• Text to be parsed...:

dateTimeToString({nnnnn}, UTC, SERVER_LANG)

replacing nnnnn with field code for Release Date custom field.