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…

Hi @Alexander_Cleary Welcome to community. I tried it out, and it works fine. Input: [image] 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

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 screensho…

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

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! …

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

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 t…

Date Function Not Accurate After Daylight Savings Time Change

Questions

alex.newpath May 15, 2024, 1:33pm 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.

Topic		Replies	Views
Wrong time in sheets Questions google-sheets	5	15	April 1, 2026
Date formatting acting weird Questions date-time-functions	7	144	January 23, 2025
Wrong time in google sheets Questions connections	1	59	February 12, 2025
Why Time Zone Return Inaccurately Questions format-date	1	32	April 17, 2025
Daylight savings changes modified scenario results Questions filters , google-sheets	5	340	July 7, 2024

Date Function Not Accurate After Daylight Savings Time Change

Related topics