Calendar date should show day of the week in the other field

[bedjik]

Hello Airtable Community,

     Question: My main field (first left field) is the "Date", next field is "Day of the Week" (single select). Is it possible to automate "Day of the Week" field so it would automatically choose the day based on the calendar date input in the "Date" field?

   Thank you in advance for your help

[pressGO_design · Accepted solution]

Yes, although you would use a formula, not at automation. More info here.

[bedjik]

Thank you, this path is a partial solution, now it shows the day of the week but in a weird format "1 - Monday", not sure how to get rid of "1 -" in the beginning

[pressGO_design · Accepted solution]

DATETIME_FORMAT({Date Field}, 'dddd')

Just use this ^^^

[bedjik]

This is exactly what I was looking for, thank you very much, you are a creative mind