Unanswered

How to convert utcNow() to different time zone?

(0) Share

Report

Posted on by Community Power Pla...

Hi everyone,

I'm trying to include the date and time in the filename of an Excel file, created through a flow. I need the time to be converted to the Japan time zone, so my code looks like this:

formatDateTime(convertTimeZone(utcNow(), 'UTC', 'JST'),'yyyyMMddhhmm')

However, this outputs an error saying that the value 'JST' is incorrect (see attachment). I also tried to replace it by 'Japan Standard Time' but the result in the same. I followed an example where it was using 'Eastern Standard Time' and that worked. So I'm wondering what's the exact syntax for the Japan time, does anyone know?

Thanks a lot!

Categories:

Building flows

errorflow.PNG

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

grantjenkins 11,063 Moderator on at

Like (2)

Report
You can use the Convert time zone action to see the list of time zones you have available. Once you've set that up you can go into Peek code to see what it generates.

{ "kind": "ConvertTimeZone", "inputs": { "baseTime": "@{utcNow()}", "formatString": "yyyyMMddhhmm", "sourceTimeZone": "UTC", "destinationTimeZone": "Tokyo Standard Time" } }

So, for your example you should be able to do the following:

convertTimeZone(utcNow(), 'UTC', 'Tokyo Standard Time', 'yyyyMMddhhmm')

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hey Grant,

Thanks a lot for your quick reply! I finally understand how to find the String values to pass as the destinationTime now. I tried with your suggestion and my filename displays the correct time.

Was this reply helpful? Yes No