Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Trouble with DATETIME_FORMAT and day of the week

1939 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")