Trouble with DATETIME_FORMAT and day of the week

1512 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

I am trying to return a day of the week (dddd) from another column with a date formatted as MM/DD/YYYY, however I keep getting an error message.

This is the formula that I’m using:

=DATETIME_FORMAT({Sales Date},dddd)

Am I doing something wrong?

thank you!!

1 Reply 1
Airtable Employee
Airtable Employee

Your format string needs to be enclosed in quotation marks, and the equals sign is not needed.

DATETIME_FORMAT({Sales Date},"dddd")