"Create JSON" node automatically converts to UTC 0

How To
, ,
1

I am currently trying to use a “Create JSON” node to convert data retrieved from Google Calendar into an API-friendly JSON to respond to a specific webhook I have. I need the time to be in the correct time zone as the time will be used to feed into an LLM, so I prefer if it is already formatted correctly as LLMs tend to get confused if I don’t format it properly.

However, whenever I use the “Create JSON” node or a “Transform to JSON” node to create a JSON string for the webhook, the node drops the timezone detail and the LLM thinks that the time is 11 hours earlier than it should be.

Here is the input:

image
image736×707 43.3 KB

and here is the output:

image
image614×523 28.7 KB

Is there a way to always ensure that the time is in the correct timezone?

Thank you.

3

Welcome to the Make community!

You have to use the formatDate function and include the timezone in your date format.

For more information, see Date Format links below:

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Getting Started

Help Centre Basics

Articles & Videos

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.