User Guide Cancel

DaysInMonth

 

Description

Determines the number of days in a month.

Returns

The number of days in the month in Date.

Category

Date and time functions

Function syntax

DaysInMonth(date)
DaysInMonth(date)
DaysInMonth(date)

See also

DayDayOfWeekDayOfWeekAsStringDayOfYearDaysInYearFirstDayOfMonth

Parameters

Parameter

Description

date

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

Usage

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

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

Example

<cfscript>
Date1 = "{ts '2018-12-06 12:13:50'}";
Date2 = "{ts '2018-02-06 12:13:50'}";
DaysInMonth= DaysInMonth(Date1)
DaysInMonth1= DaysInMonth(Date2)
writeOutput(Date1 & "<br/>")
writeOutput("Number of days in this month is " & DaysInMonth & "<br/>")
writeOutput(Date2 & "<br/>")
writeOutput("Number of days in this month is " & DaysInMonth1 & "<br/>")
</cfscript>
<cfscript> Date1 = "{ts '2018-12-06 12:13:50'}"; Date2 = "{ts '2018-02-06 12:13:50'}"; DaysInMonth= DaysInMonth(Date1) DaysInMonth1= DaysInMonth(Date2) writeOutput(Date1 & "<br/>") writeOutput("Number of days in this month is " & DaysInMonth & "<br/>") writeOutput(Date2 & "<br/>") writeOutput("Number of days in this month is " & DaysInMonth1 & "<br/>") </cfscript>
<cfscript>
    Date1 = "{ts '2018-12-06 12:13:50'}";
    Date2 = "{ts '2018-02-06 12:13:50'}";
    DaysInMonth= DaysInMonth(Date1)
    DaysInMonth1= DaysInMonth(Date2)
    writeOutput(Date1 & "<br/>")
    writeOutput("Number of days in this month is  " & DaysInMonth & "<br/>")
    writeOutput(Date2 & "<br/>")
    writeOutput("Number of days in this month is " & DaysInMonth1 & "<br/>")
</cfscript>

Output

{ts '2018-12-06 12:13:50'}
Number of days in this month is 31
{ts '2018-02-06 12:13:50'}
Number of days in this month is 28

Get help faster and easier

New user?