<< Click to Display Table of Contents >> Navigation:  Date / Time functions > Month

Description

Returns an Integer specifying a whole number between 1 and 12, inclusive, representing the month of the year.

Syntax

MyMonth = Month(date)

Example

Dim MyDate As Date
Dim MyMonth As Integer
MyDate = #May 20, 1963#   ' Assign a date.
MyMonth = Month(MyDate)   ' MyMonth contains 5