
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 02, 2024 05:46 PM
I've searched on the community for solutions to combining one field that contains a date and another field with a duration to create a datetime field, but haven't come across any solutions to solve it. I'm using the DATEADD() formula but Airtable is not returning a correct results. What am I missing?
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 02, 2024 08:00 PM
Hm I tried it and it works fine:
Link to base
Might be a timezone thing? Try setting both the date and formula field to use the same timezone?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 02, 2024 08:00 PM
Hm I tried it and it works fine:
Link to base
Might be a timezone thing? Try setting both the date and formula field to use the same timezone?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 03, 2024 09:48 AM
Counterintuitively, that was what worked. I think Airtable has a glitch with the Date field where, despite the format being set to Local, the time zone display forces GMT. Then for the formula you cannot use your correct timezeone - you have to also use GMT. Thanks for clarifying. I will submit this bug to Airtable for review.
