You are here: Functions > CDOW()

CDOW()

CDOW() returns the name of the day of the week for a specified date. To display the day of the week as a number, use the DOW() function.

Function Format

CDOW(D,N)

D specifies the datetime
N specifies the field length. To display abbreviated day of the week names, specify a shorter field length

CDOW() returns the name of the day of the week for the supplied DateTime with a length N.

If the DateTime is invalid or blank, then CDOW() returns blanks with a length N.

Valid dates are in the range January 2, 1900 to December 31, 9999.

Examples

To display the name of the day of the week:

CDOW(`20000801`,7) = "Tuesday"

CDOW(`20000801`,3) = "Tue"