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?
Page 1 / 1
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?
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?
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.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.