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.

 

Related Topics