$image\Dql_0023.gif$ day

The day function extracts the day of the month (1-31) from a date value.

Syntax

day( DATE VALUE)

Returns

An integer value between 1 and 31

The date format selected in Windows Control Panel changes the date sequence but does not affect which value is returned by a Date function.

Examples

day(12/31/01)

Returns:31 (United States format)

day(31/12/01)

Returns:31 (Australian, English Canadian, South American, most European formats)

day(01/12/31)

Returns:31 (Austrian, French Canadian, Taiwanese, South Korean, some European formats)