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
Combined Date and Time - Stuck
+12Best answer by TheTimeSavingCo
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?
+31Hm 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?
+12Hm 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.
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.