Help

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

Solved
Jump to Solution
855 0
cancel
Showing results for 
Search instead for 
Did you mean: 
bedjik
6 - Interface Innovator
6 - Interface Innovator

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

2 Solutions

Accepted Solutions

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

See Solution in Thread

pressGO_design
9 - Sun
9 - Sun
DATETIME_FORMAT({Date Field}, 'dddd')

Just use this ^^^

See Solution in Thread

4 Replies 4

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

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
9 - Sun
9 - Sun
DATETIME_FORMAT({Date Field}, 'dddd')

Just use this ^^^

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