Skip to main content

Hello!

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? 

Thank you!

 

 

 

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). 

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). 


Thank you for your response! Is there any way to make them both appear in EST?

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?

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?


I would also like to know this. It's very frustrating!

Has anybody figured out this ? My goal is to add "duration" field into "date only" field with formula. But stuck on this timezone problem and formula keeps returning wrong timezone no matter where I adjust timezone with SET_TIMEZONE.

I'm having this same issue. Has anyone figured out a solution?

I have made this formula to my situation. I wanted to convert "date only" field to "date+time" using "duration" field. Everything needed convert to string, and back to the date format. Here is my formula, I hope it helps:

IF({📅 Start Day},
  DATEADD(
    DATETIME_PARSE(DATETIME_FORMAT({📅 Start Day}, 'YYYYMMDD-HHmm') & "+" &
      DATETIME_FORMAT(SET_TIMEZONE(DATETIME_PARSE(DATETIME_FORMAT({📅 Start Day}, 'YYYYMMDD-HHmm'), 'YYYYMMDD-HHmm'), 'europe/helsinki'), "HHmm"), 
    'YYYYMMDD-HHmmZZ'), {🕑 Start Time}, 'seconds'
  )
)

Reply


Terms & Conditions