User Guide Cancel

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)
Month(date)
Month(date)

See also

DatePartMonthAsStringQuarter

Parameters

Parameter

Description

date

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

Usage

When passing a date/time value as a string, 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

<cfscript>
curdatetime = Now();
writeOutput(curdatetime & "<br/>");
Writeoutput(" it is month " & month(curdatetime));
</cfscript>
<cfscript> curdatetime = Now(); writeOutput(curdatetime & "<br/>"); Writeoutput(" it is month " & month(curdatetime)); </cfscript>
<cfscript>
    curdatetime = Now();
    writeOutput(curdatetime & "<br/>");
    Writeoutput(" it is month " & month(curdatetime)); 
</cfscript>

Output

{ts '2018-11-06 06:51:58'}
it is month 11

Get help faster and easier

New user?