
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 25, 2023 01:30 AM
Hi
I have a formula
DATEADD({Kick off},{Time Estimate (Fibonacci Minutes)},"minutes")
- {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?
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 25, 2023 09:44 AM - edited ‎Sep 25, 2023 09:44 AM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 25, 2023 09:44 AM - edited ‎Sep 25, 2023 09:44 AM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 26, 2023 01:21 AM
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.
