Parsing JSON's help

Hi team - hope someone can help - i’m doing an API request and the formating is coming out wrong. I’m getting a date/time in the JSON it looks like this: ,“endAt”:“2023-05-19T18:00:00-07:00”," in the parsed version it looks like 2023-05-19 13:00 - so its taking the timezone into account (which is quite clever) but I want it to show 6 pm…

is their away to do this?

Hi Bill,

The JSON timestamp is converted to your local time. If you want to keep it in the other timezone, you can add the time difference to the parsed timestamp. For instance, to add 7 hours, add 7/24 (a timestamp in EasyMorph is an integer number of days). E.g.:

now() + 7/24

Hi Bill,

The provided date/time is converted to 2023-05-20 01:00:00 on my side, which is the corresponding UTC time. Can you please confirm that you experience the same behavior?