Re: Day of Week Based on Calendar Date?

5488 2
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

We have a field for Calendar Date. Is there a way to have the day of the week (Monday, Tuesday, etc.) that corresponds to that calendar date autopopulate in another field?

12 Replies 12
5 - Automation Enthusiast
5 - Automation Enthusiast

hey everybody, did you guys ever see something like this before? if yes, what could be the reason. all the events are created by someone else except the one shows the same date with a different day. would appreciate if anyone can help me outairtableSS2 airtableSS1

Welcome to the Airtable community.

When you use DATETIME_FORMAT, the formula calculates the date based on GMT, unless you include the SET_TIMEZONE. When it is 5pm where you live, it is midnight GMT.

Here is an example. The function is documented in the formula field reference, and the available time zones are documented here.

DATETIME_FORMAT(SET_TIMEZONE({Date}, 'America/Los_Angeles'), 'dddd')

great! thank you for a straightaway answer!