Type
Date Function

Purpose
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)