The day function extracts the day of the month (1-31) from a date value.
The date format selected in Windows Control Panel changes the date sequence but does not affect which value is returned by a Date function.
Date Value
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)
The day function extracts the day of the month (1-31) from a date value.
Syntax
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)
Product: . Written by Kevin O'Donnell 17/12/15 at 13:33:56
Product: Dataease [{8}]FIVE. Written by grohmann.papier@t-online.de 17/12/15 at 19:33:15
Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 18/12/15 at 02:33:04
Product: Dataease [{8}]FIVE. Written by DataEase 18/12/15 at 12:16:37
Product: LegEasy DOS. Written by Steinar Svinø 03/12/20 at 18:29:27
Product: LegEasy DOS. Written by DataEase 04/12/20 at 11:14:56
Product: LegEasy DOS. Written by Steinar Svinø 04/12/20 at 11:42:04
Product: LegEasy DOS. Written by DataEase 11/12/20 at 11:48:02
Product: LegEasy DOS. Written by DataEase 14/12/20 at 12:34:56
Product: Dataease [{8}]FIVE. Written by DataEase 26/07/13 at 11:34:13
Product: Dataease [{8}]FIVE. Written by DataEase 21/01/14 at 17:08:18
Product: Dataease [{8}]FIVE. Written by DataEase 30/09/14 at 22:25:27
Product: Dataease [{8}]FIVE. Written by DataEase 04/12/15 at 00:12:18