Convert from one time zone to another time zone

[Kurumi]

Here's a sample use case to convert timestamps or Date/Time to another timezone. In this case, convert Pacific Time to Central and Eastern.

Central Timezone

Request:
Convert the following date and time from "[@field:Date_Submitted]" which is Pacific Standard Time (PST) to Central Standard Time (CST).
Change to the format of mm/dd/YYYY, HH:MM AM or PM
Return only the final result.

Result:

Eastern Timezone

Request:
Convert the following date and time from "[@field:Date_Submitted]" which is Pacific Standard Time (PST) to Eastern Standard Time (EST).
Change to the format of mm/dd/YYYY, HH:MM AM or PM
Return only the final result.

Result:

 

Change the 'Date_Submitted' field to your right field name. You may also change the format of the date and time based on your location. 

[Heather]

Thank you for posting this, @Kurumi! Your solution gave me an idea of adding a field that specifies the time zone, then using AI to automatically convert the Date/Time field based on that. It could streamline handling time data across different regions.  👍

Request:
Convert [@field:Submitted_Date] to [@field:Timezone] timezone and display in MM-DD-YYYY hh:mm:ss AM/PM format. Display result only.

Result:

[Kurumi]

Hi @Heather - Glad it helped! Adding a time zone field and automating the conversion sounds like a smart move  It would definitely save a lot of manual adjustments and ensure accuracy across regions.