Returns a whole number between 1 and 31, inclusive, representing the day of the month.
Day(date)
The date argument is any numeric or string expression, or any combination, that can represent a date. If date contains Null, Null is returned.
Date Function, Date Statement, Hour Function, Minute Function, Month Function, Now Function, Second Function, Weekday Function, Year Function.
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.
MyDate = #February 12, 1969# ' Assign a date.= Day(MyDate) ' MyDay contains 12.