Returns the numeric day of the month for a given Date or DateTime expression.
Syntax
DAY(dExpression | tExpression)
Returns
Numeric
Arguments
dExpression
Specifies a date from which DAY( ) returns a day of the month. dExpression can be a date literal, a Date-type variable, an array element, or a date field.
tExpression
Specifies a date or time from which DAY( ) returns a day of the month. dExpression can be a DateTime literal, a DateTime-type variable, an array element, or a DateTime field.
Remarks
DAY( ) returns a number from 1 through 31.