Returns a Variant (Integer) specifying a whole number between 1 and 31, inclusive, representing the day of the month.
Day( date )
The required dateargument is any Variant, numeric expression, string expression, or any combination of these that can represent a date. If date contains Null, Null is returned.
This example uses the Day function to obtain the day of the month from a specified date. In the development environment, the date literal is displayed in short format using the locale settings of your code.
Dim MyDate, MyDay
MyDate = #February 12, 1969# ' Assign a date.
MyDay = Day(MyDate) ' MyDay contains 12.