Skip to main content

Trouble with DATETIME_FORMAT and day of the week

  • July 21, 2017
  • 1 reply
  • 20 views
D
Forum|alt.badge.img+2

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

    M
    Forum|alt.badge.img+12
    • Matt_Bush
    • Inspiring
    • July 21, 2017

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

    DATETIME_FORMAT({Sales Date},"dddd")

    Terms & ConditionsAccessibility statement