DATE ADD is calculating from an hour before it should.

[Jim_Hitch3]

Hi 

I have a formula

DATEADD({Kick off},{Time Estimate (Fibonacci Minutes)},"minutes")

Whereby 

• {Kick off} is an date field set to ISO and 24 hour time
• {Time Estimate (Fibonacci Minutes)} is a drop down with a Fibonacci sequence

I want the DATEADD formula above to return the expected job completion date and time so that I can feed it straight into my calendar. Weirdly, it's an hour out.

For eg a kick off date of  2023-05-10 00:01 with a fibonacci of 21 returns 2023-05-09 23:22, when it should be 2023-05-10 00:22.

Any ideas?

[Alessio_Monino · Accepted solution]

Hi @Jim_Hitch3,

Is it potentially a date format issue? You can choose your preferred date format by editing the field configuration and selecting which timezone you want the field to be set in - you would likely want all your date fields to have the same timezone so that they all showcase the same date and time

I hope this helps!

Website: https://alessiomonino.com
Calendly: https://alessiomonino.com/contact
Email: alessio.monino@gmail.com

[Jim_Hitch3]

Hi @Alessio_Monino 

Thanks so much for taking the time to reply. I woke up this morning with exactly that thought in my head! And you are absolutely right. Fixed!

Thanks again.