Setting Timezone without Time in Date Field

[AnitaHallberg]

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!

 

 

 

[kuovonne]

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

[AnitaHallberg]

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

[lailah]

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?

[Meagan_Caesar]

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

[Lassi_Seppa]

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.

[Allison_BM]

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

[Lassi_Seppa]

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'

  )

)