Added by Kurtis Cruzada, last edited by Kurtis Cruzada on Oct 02, 2007  (view change)

Labels:

Enter labels to add to this page:
Wait Image 
Looking for a label? Just start typing.

Returns the day of the month for a date, 1 through 31.

Syntax

DAY( date )

date 

format: month/day/year or  year-month-day

year (required) - An integer between 1583 and 9956, or 0 - 99.
month (required) - An integer between 1 and 12 representing month.
day (required) - An integer between 1 and 31 representing day of month.

Examples

Syntax Result
report: DAY("6/21/69") 21
report: DAY("1969-6-21") 21
BDate = "6/21/69"
 
report: DAY([BDate])
21