Whatever message this page gives is out now! Go check it out!

DaysInMonth

Last update:
May 18, 2026

Description

Determines the number of days in a month.

Returns

The number of days in the month in Date.

Category

Function syntax

DaysInMonth(date)

See also

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

Share this page

Was this page helpful?
We're glad. Tell us how this page helped.
We're sorry. Can you tell us what didn't work for you?
Thank you for your feedback. Your response will help improve this page.

On this page