Help

Trouble with DATETIME_FORMAT and day of the week

1421 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniel_Kuney
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
Matt_Bush
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")