Skip to content

DOW ​

Returns the Numeric value (1-7) of the day of week for a given date.

Reporting Area(s) ​

General

Required Parameters ​

  1. 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.

CDOW
CTOD
DATE
DTOC
TRIMDATE
NICEDATE
CMONTH
MONTH
YEAR