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

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>

Output

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

This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License  Twitter™ and Facebook posts are not covered under the terms of Creative Commons.

Legal Notices   |   Online Privacy Policy