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)
@Joe ... check out the format(datetime, format) ... put something like
format('My Date Field', "ddd");
in a function or after update trigger.
Sure.. you can find the function defintion here.
Then use your browsers search (ctl+f .. or whatever) to find format(date