Month

Description

Extracts the month value from a date/time object.

Returns

The ordinal value of the month, in the range 1 (January) - 12 (December).

Category

Date and time functions

Function syntax

Month(date)

See also

DatePart, MonthAsString, Quarter

Parameters

Parameter Description

date

Date/time object, in the range 100 AD-9999 AD.

Usage

When passing a date/time value as a string, you must enclose it in quotation marks. Otherwise, it is interpreted as a number representation of a date/time object.

Note: You can pass the CreateDate function or the Now function as the date parameter of this function; for example: #Month(CreateDate(2001, 3, 3))#.

Example

<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>

View comments in LiveDocs