Issue #844 resolved
Melissa Hutson
created an issue

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.

Comments (2)

  1. Fidel Castro Armario repo owner

    Hi @Melissa Hutson,

    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.

  2. Log in to comment