Wrong time in sheets

Questions
1

:bullseye: What is your goal?

Hello,can you advise me,why in google sheets its time, one hour late ? Time zones are the same in make.com and google sheets as well. I am sure,its a simple solve,thank you.

:thinking: What is the problem & what have you tried?

Already tried those formula :
{{formatDate(addHours(now; 1); " ““DD/MM/YYYY HH:mm””“)}} → on google sheets +1 from the normal time
{{formatDate(addHours(now; -1); " ““DD/MM/YYYY HH:mm”””)}} → on google sheets -1h from the normal time
{{formatDate(" ““DD/MM/YYYY HH:mm””"; “Europe/Paris”)}} → on google sheets, -1h from the normal time

3

Hey there,

It looks like your last formula broke during pasting and isn’t showing the argument. Can you use the code formatting to show the formulas?

4

Sorry, the last one is :

{{formatDate(now; “DD/MM/YYYY HH:mm”; “Europe/Paris”)}} → on google sheets, -1h from the normal time

5

Are you using quotes for the parameters? Like “DD/MM/YYYY HH:mm”?

If so, just remove them and leave only the string values.

6

Wtf so simple, thanks a lot !