DATE ADD is calculating from an hour before it should.

Question

Hi I have a formulaDATEADD({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 sequenceI 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 Answer

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 timeI hope this helps!Website: https://alessiomonino.comCalendly: https://alessiomonino.com/contactEmail: alessio.monino@gmail.com

Jim_Hitch3 · Answer

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.

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded