Data Type: Any valid date expression
Any expression capable of conversion to a Date.
Variant of type Integer.
Returns a variant integer data type that can take on a value
ranging from 1 to 31, representing the day of the month of
dateexpression, the argument passed to
the Day function, must be a valid date/time or
dateexpression can be any
variant, numeric expression, or string expression that
represents a valid date.
The range of
1/1/100 to 12/31/9999.
Null is returned.
When working with dates, always check that a date is valid using the IsDate function prior to passing it as a function parameter.
dateexpression omits the
year, Day still returns a valid day.
If the day portion of
dateexpression is outside its valid
range, the function generates runtime error 13, “Type mismatch.”
This is also true if the day and month portion of
dateexpression is 2/29 for a nonleap
To return the day of the week, use the WeekDay function.