Dec 21, 2018 10:35 AM
I am trying to enter a date as a starting date, and enter a formula in the next field that adds 1 day (24 hours), which would be the due date for the task in the original field.
This formula is giving me the correct day and format, but is calculating the time to be 32 hours later (it’s adding 6 hours to the original time of day): DATEADD({In-Home Estimate Date and Time}, 1, ‘days’)
It seems like it should be so simple, what am I doing wrong?
Dec 21, 2018 10:48 AM
Check to see if the “Use same Timezone for all users” option is checked in your formula field. If it is checked, try unchecking it and see if that fixes it. If it is not checked, then try checking it and see if that fixes it.
Airtable has some weird stuff going on under the hood sometimes with timezones across formula fields, and I usually find that some adjustment of that option amongst all the fields fixes the issue. Don’t know why or what the rhyme/reason is really.
Dec 21, 2018 10:52 AM
Wow, that fixed it immediately. Thank you so much!!