DOW
Returns the Numeric value (1-7) of the day of week for a given date.
Reporting Area(s)
General
Required Parameters
- Date field (i.e. cobegdate, coenddate)
Optional Parameters
None
Example(s)
DOW(cobegdate) returns the number day of the week for Monday, September 5, 2017 as 2 ( where Sunday = 1 and Saturday = 7)
Notes
Standard FoxPro Function
USED FOR: To order a set of dates by day of week (so Mon,Tues,Wed,Thur,Fri … in DOW format 2,3,4,5,6 ) are sorted in the correct Day of Week.