Day of Week Based on Calendar Date?

[Roseann_Marulli]

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?

[Orhan_Baran]

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 out

[kuovonne]

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

[Orhan_Baran]

great! thank you for a straightaway answer!