Trouble with DATETIME_FORMAT and day of the week


#1

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!!


#2

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

DATETIME_FORMAT({Sales Date},"dddd")