Last updated on
Apr 27, 2021 05:38:59 AM GMT
|
Also Applies to ColdFusion
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
Day, DayOfWeek, DayOfWeekAsString, DayOfYear, DaysInYear, FirstDayOfMonth
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
Sign in to your account