Help

DATE ADD is calculating from an hour before it should.

Topic Labels: Dates & Timezones
Solved
Jump to Solution
559 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Jim_Hitch3
4 - Data Explorer
4 - Data Explorer

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?

 

1 Solution

Accepted Solutions
Alessio_Monino
9 - Sun
9 - Sun

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

See Solution in Thread

2 Replies 2
Alessio_Monino
9 - Sun
9 - Sun

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
4 - Data Explorer
4 - Data Explorer

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.