The day function extracts the day of the month (1-31) from a date value.
day( DATE VALUE)
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.
Returns:31 (United States format)
Returns:31 (Australian, English Canadian, South American, most European formats)
Returns:31 (Austrian, French Canadian, Taiwanese, South Korean, some European formats)