Access: Day Function
In Access, the Day function returns the day of the month (a number from 1 to 31) given a date value.
The syntax for the Day function is:
Day ( date_value )
date_value is a valid date.
For example:
Day (#22/11/2003#) would return 22 Day (#01/01/1998#) would return 1
VBA Code
The Day function can be used in VBA code. For example:
Dim LDay As Integer
LDay = Day(#12/03/2001#)
In this example, the variable called LDay would now contain the value of 12.
SQL/Queries
You can also use the Day function in a query.
