Time changes date

[Cody_Winchester]

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?

[TheTimeSavingCo · Accepted solution]

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?

[Cody_Winchester]

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.