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
-
@Joe ... check out the format(datetime, format) ... put something like
format('My Date Field', "ddd");
in a function or after update trigger.
-
Perfect!
Thanks
Joe
-
@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
Content aside
- 5 yrs agoLast active
- 3Replies
- 1730Views