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)

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>

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

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