Sending timestamp to Google Sheets with correct timezone

[strongbow]

I’m trying to send a timestamp to a Google Sheet. Therefore, I use the expression $now.format(“HH:mm”).toString(). In n8n, the timestamp looks correct (see screenshot).

However, in Google Sheets, the string value is 2 hours off (so it does not consider the timezone).

Any thought on how to solve this?

[n8n]

It looks like your topic is missing some important information. Could you provide the following if applicable.

• n8n version:
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app):
• Operating system:

[aya]

Hi @strongbow,

• To format a DateTime object based on the user’s locale settings:
  {{$now.format("HH:mm").toLocaleString()}}
• If you want to specify a timezone:
  {{$now.setZone('America/New_York').format("HH:mm")}}

You can find more information on how to n8n handle date and time in the docs here: Handling dates | n8n Docs

Hope that helps!

[strongbow]

Hey @aya, thanks for your response!
toLocaleString() didn’t work
setZone('Berlin/Europe') did work - although locale and timezone I set were the same.

[aya]

Could you tell me what the output looks like when you try toLocaleString()

[Imperol]

@strongbow Check this thread on using time and dates in n8n

Working with time and dates in n8n

Manipulating Time and dates in n8n Time and dates are some of the key data we use on an almost daily basis. How about when iut comes to n8n, how do we format this data for easy use. For a while I have been working with n8n and dates and time has been one of the interesting parts on it. I will show you a few tricks you can use in n8n to do quite a few things and manipulations on time and dates using simple code snippets as listed below. Filter dates that are not weekends Minus time and dates f…

[aya]

this is great @Imperol!