MONTH(theDate as Date)
Description
Returns an integer with the months value from a date
Example
Dim theDate as Date
Dim result as Integer
theDate=DateVal(1995,6,23)
result=Month(theDate) 'will calculate result=6