Month

Returns the ordinal for the month, ranging from 1 (January) to 12 (December).

See also DatePart, MonthAsString, and Quarter.

Syntax

Month(Date)

date

Any date.

Usage

Years from 0 to 29 are interpreted as 21^st century values. Years 30 to 99 are interpreted as 20^th century values.

When passing a date/time value as a string, make sure it is enclosed in quotes. Otherwise, it is interpreted as a number representation of a date/time object, returning undesired results.

Examples

<!--- shows the value of the Month function --->
<HTML>
<HEAD>
<TITLE>
Month Example
</TITLE>
</HEAD>

<BODY bgcolor=silver>
<H3>Month Example</H3>

<CFIF IsDefined("FORM.year")>
More information about your date:
<CFSET yourDate=CreateDate(FORM.year, FORM.month, FORM.day)>

<CFOUTPUT>
<P>Your date, #DateFormat(yourDate)#.
<BR>It is #DayofWeekAsString(DayOfWeek(yourDate))#, day
  #DayOfWeek(yourDate)# in the week.
<BR>This is day #Day(yourDate)# in the month of
  #MonthAsString(Month(yourDate))#, which has
    #DaysInMonth(yourDate)# days.
<BR>We are in week #Week(yourDate)# of #Year(yourDate)# (day
  #DayofYear(yourDate)# of #DaysinYear(yourDate)#).  
<BR><CFIF IsLeapYear(Year(yourDat"))>This is a leap
  year<CFELSE>This is not a leap year</CFIF>
</CFOUTPUT>
</CFIF>
...