<< Click to Display Table of Contents >> Navigation:  Available Functions > DOW()

Syntax

DOW( <DateValue> )

 

Purpose

To determine the numeric Day Of Week for a given date value.

 

Parameters

<DateValue> may be the name of a date field (such as the .Donation_Date. field), but it may also be any value of Date type -- such as the current date returned by the "Date()" function.

 

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 is seven (Saturday). If <DateValue> is empty (" / / "), DOW() returns zero.

 

Usage

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 value instead of a number.

 

Example

The following examples illustrate DOW() and its relationship to CDOW():