Show day of the week from date field
J

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

Ninox Profile

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

 

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

 

in a function or after update trigger. 

J

Perfect!

Thanks

Joe

Ninox Profile

@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 

 

Reply