Is there way to show PST to UTC time format

Integrator.io
1

Hello,

following date

{
"SiteId": "XXXX",
"Identifier": "197128335067",
"Quantity": 1,
"Date": "2024-06-12T15:33:40-07:00",
"TransactionId": "SO16811522",
"Context": {}
}

should be shown in the following "2024-06-12T22:33:40.4040Z”. ?

I tried using date format but not able to make it happen.

2

Hi @harishbakka,

I'm moving this post to the Troubleshoot custom flows section for more visibility! Thanks!

3

Work around

{
"Date_1":"{{dateFormat 'YYYY-MM-DDTHH:mm:ss.sss' Date 'YYYY-MM-DDTHH:mm:ssZ'}}Z"
"Date_2": "{{dateAdd (dateFormat "YYYY-MM-DDTHH:mm:ss.sss" Date "YYYY-MM-DDTHH:mm:ssZ" "UTC")}}",
"Date_3":"{{dateFormat 'YYYY-MM-DDTHH:mm:ss.sss' Date 'YYYY-MM-DDTHH:mm:ssZ' 'America/Los_Angeles'}}Z"
}

4

@harishbakka you should put the Z in square brackets:

{{dateFormat "YYYY-MM-DDTHH:mm:ss.ssss[Z]" Date "YYYY-MM-DDTHH:mm:ssZ"}}

5301043caa20740200000001-e74033d33f5c44d09f4ed255198cfc8c.png
5301043caa20740200000001-e74033d33f5c44d09f4ed255198cfc8c.png2298×390 87.9 KB

I'm not sure why you have the seconds repeating in the milliseconds position, but if you mean to just have zeros, then you can do:

{{dateFormat "YYYY-MM-DDTHH:mm:ss.SSSS[Z]" Date "YYYY-MM-DDTHH:mm:ssZ"}}