Syntax

Month(date)

Description

Returns the month of the date encoded in the specified date parameter.

Comments

The value returned is as an Integer between 1 and 12 inclusive.

The date parameter is any expression that converts to a Date.

Example

This example returns the current month in a dialog box.

Sub Main()
  mons$ ="Jan.,Feb.,Mar.,Apr.,May,Jun.,Jul.,Aug.,Sep.,Oct.,Nov.,Dec."
  tdate$ = Date$
  tmonth! = Month(DateValue(tdate$))
  MsgBox "The current month is: " & Item$(mons$,tmonth!)
End Sub

See Also

Day (function) Minute (function); Second (function); Year (function); Hour (function); Weekday (function); DatePart (function).

M