Day formula not working - global team

[automadien]

Hi all, thanks in advance for reading.

We have the fairly standard day formula implemented in our Airtable:
IF({Live Date}=BLANK(),"", DATETIME_FORMAT({Live Date},‘ddd’))

However, for just one week, if the time is before 1AM on Live Date, it appears as the day before.

I’m aware a standard fix for this is overriding time zones however that won’t work for us - we’re a global team so the localised time displays are vital, especially as we work in publishing.

So, I’m kind of stumped. Any ideas?

[kuovonne]

Do you have a specific time zone for your headquarters that determines the date? If so, you can set DATETIME_FORMAT() to use that time zone. You can see the formula field reference for more info. Or you can use the Ready-Made Formulas app to help you create the formula.

[ScottWorld]

Also, for a deep dive into time zones and how you could use multiple time zones in a base, check out my sample base & training video here:

Airtable

Time Zones: Working with multiple different time zones in Airtable - Airtable...

This Airtable base solves the problem of events taking place in different time zones, and users wanting to know what time those events are taking place in...

[automadien]

All of the respective locations need to be able to use AT in their time zone unfortunately, and we can’t identify a ready made that would work!

[kuovonne]

automadien:

All of the respective locations need to be able to use AT in their time zone

DATETIME_FORMAT always returns the result for a particular time zone. It cannot adapt to the user’s time zone on the fly. Only date/time fields or formulas that return a date/time object (versus a string) can be shown in the local time zone.

If you have a limited number of time zones in your team, you could have a different formula field for each time zone, but that may be more effort than it is worth.

[automadien]

Makes sense - not sure how to fix this error within Airtable then as it’s literally just one week affected showing incorrect days.