Skip to main content
Solved

How can I see the name of a weekday

  • August 31, 2020
  • 2 replies
  • 111 views
K

I have a simple date in my table and I simply want to have the name of the weekday displayed (e.g. in another column). Does this work with a formula?

Best answer by Jeremy_Oglesby

Yes, you could use a Formula field to do this, by entering this formula:

DATETIME_FORMAT({Your Date Field}, 'dddd')

Here’s a list of all the “Format Specifiers” that can be used with the DATETIME_FORMAT() function in case you want to try some others:

    2 replies

    J
    Forum|alt.badge.img+18

    Yes, you could use a Formula field to do this, by entering this formula:

    DATETIME_FORMAT({Your Date Field}, 'dddd')

    Here’s a list of all the “Format Specifiers” that can be used with the DATETIME_FORMAT() function in case you want to try some others:

    kuovonne
    K
    • Kay_Frank
    • Author
    • New Participant
    • August 31, 2020

    Yes, you could use a Formula field to do this, by entering this formula:

    DATETIME_FORMAT({Your Date Field}, 'dddd')

    Here’s a list of all the “Format Specifiers” that can be used with the DATETIME_FORMAT() function in case you want to try some others:


    THANK YOU!!! Yes, finally, this is so satisfying and yet so simple! Keep up the good work!

    J
    Terms & ConditionsAccessibility statement