0

Show day of the week from date field

I have a date field in one of my tables and I want a secound field in the same table that shows the day of the week based on what the date fields input is:

Example: my date field has (11/14/2019) I want a secound field that show (Thur or Thursday)

Thanks,

Joe

3 replies

null
    • Mconneen
    • 5 yrs ago
    • Reported - view

    @Joe ...  check out the format(datetime, format) ... put something like

     

    format('My Date Field', "ddd");

     

    in a function or after update trigger. 

    • Joe_Cirillo
    • 5 yrs ago
    • Reported - view

    Perfect!

    Thanks

    Joe

    • Mconneen
    • 5 yrs ago
    • Reported - view

    @Joe 

     

    Sure.. you can find the function defintion here. 

    https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language

     

    Then use your browsers search (ctl+f .. or whatever) to find format(date 

Login to reply

Content aside

  • 5 yrs agoLast active
  • 3Replies
  • 1738Views