Feb 20, 2023 11:06 AM - edited Feb 20, 2023 11:11 AM
I'm having issues with Airtable's default GMT timezone. I have a Date field (which I do not want to have time displayed for) as well as a formula field using the DATEADD formula to calculate the next time a task is due, based on frequency.
In the formula field, I can specify timezone. In the Date field, I can't - without adding the time. Because of that, it's calculating incorrectly - everything is off by a day. Only when I add a time do the dates show up correctly.
Is there any way to fix this? Do I need to add something to my DATEADD formula?
Feb 20, 2023 03:00 PM
Date only fields are always midnight GMT when used in formulas. Since your formula result is a date, set the formatting tabl of the formula field to use the same Timezone for everyone (GMT).
Feb 22, 2023 06:57 AM
Thank you for your response! Is there any way to make them both appear in EST?
Mar 13, 2023 07:17 PM
I would also like to know how to set the time zone on a date field without displaying the time. Why is the "Use the same time zone for all collaborators" option not available without the time being displayed? Is there a way to enable it?