Date Function Not Accurate After Daylight Savings Time Change

How To
1

Hi Guys

Does anyone have the solution for this? I use the Date Time Function in make.com. I’m on EST time and I use that region, but since daylight savings time it’s wrong, it says the time is 12.33 when it is 13.33

I update a google sheets cell using this formula from make.com - {{formatDate(now; “DD MMM YYYY HH:mm”; “EST”)}}

2

Hi @Alexander_Cleary

Welcome to community.
I tried it out, and it works fine.
Input:

image
image811×430 36 KB

output
image

If you require additional assistance, please don’t hesitate to reach out to us.

MSquare Support | Book Live Implementation
Visit us here
Youtube Channel

  • Msquare
2 Likes
3

Hi…

Thanks for the reply but… nope!

I just tried it out again myself… and i can confirm 100% it is incorrect

It is currently 2.25 am, it says it is 1.25am… i have a screenshot i can show you… from my make scenario… i got the output details just like you

But i don’t know how to attach a screenshot to this post?

4

It’s updating google sheets btw and the local in google sheets is also set to EST.

I can confirm the google sheets time is setup correctly also, because when i put the formula now() into google sheets it gives me the correct time

So it must be make.com that is incorrect

5

Welcome to the Make community!

For quicker assistance with bugs and technical problems, you may want to contact support directly. They respond very quickly and update you frequently on the status of their investigation.

Hope you can share the resolution with us if you manage to solve this problem!

2 Likes
6

What is your organization timezone and web timezone set to on your make.com profile?

2 Likes
7

I noticed if you have a leading space on the timezone parameter it breaks…

So

{{formatDate(now; “DD.MM.YYYY hh:mm A”; " EST")}}

shows incorrect time (4 hours later)

{{formatDate(now; “DD.MM.YYYY hh:mm A”; “EST”)}}

shows correct time, check to make sure you don’t have any leading spaces on the timezone parameter.

–
Alex Sirota
Director of NewPath Consulting - we are :superhero: Make Heroes! :woman_superhero:t4:

:heart_on_fire: Check out my series of videos and scenario walkthroughs for Make Newbies :heart_on_fire:

My Solutions on Make Community

2 Likes
8

You may also want to watch the video on how the org and web time zone settings affect what you see in the input and output bundles in Make.

2 Likes