DOW()

Convert a date value to a number representing the day of the week.

Syntax

DOW(<dDate>) --> nDay

Arguments

<dDate> --> is a date value to convert.

Returns

DOW() returns the day of the week as a number between zero and seven. The first day of the week is one (Sunday) and the last day is seven (Saturday). If <dDate> is empty, DOW() returns zero.

Description

DOW() is a date conversion function that converts a date value to a number identifying the day of the week. It is useful when you want date calculations on a weekly basis. DOW() is similar to CDOW() which returns the day of week as a character string instead of a number.

Examples

DOW(Today())

* Returns number representing day of week

CDOW(Today())

* Returns name of day of week

____________________________