DaysInMonth

Returns the number of days in the specified month (Date).

See also Day, DayOfWeek, DayOfWeekAsString, DayOfYear, DaysInYear, and FirstDayOfMonth.

Syntax

DaysInMonth(date)
date

Any date.

Usage

Years from 0 to 29 are interpreted as 21st century values. Years 30 to 99 are interpreted as 20th century values.

When passing a date/time value as a string, make sure it is enclosed in quotes. Otherwise, it is interpreted as a number representation of a date/time object, returning undesired results.

Examples

<!--- shows the value of the DaysInMonth function --->
<HTML>
<HEAD>
<TITLE>
DaysInMonth Example
</TITLE>
</HEAD>

<BODY BGCOLOR=silver>
<H3>DaysInMonth Example</H3>

<CFIF IsDefined("FORM.year")>
More information about your date:
<CFSET yourDate = CreateDate(FORM.year, FORM.month, FORM.day)>

<CFOUTPUT>
<P>Your date, #DateFormat(yourDate)#.
<BR>It is #DayofWeekAsString(DayOfWeek(yourDate))#, day
  #DayOfWeek(yourDate)# in the week.
<BR>This is day #Day(YourDate)# in the month of
  #MonthAsString(Month(yourDate))#, which has
    #DaysInMonth(yourDate)# days.
<BR>We are in week #Week(yourDate)# of #Year(YourDate)# (day
  #DayofYear(yourDate)# of #DaysinYear(yourDate)#).  
<BR><CFIF IsLeapYear(Year(yourDate))>This is a leap year
    <CFELSE>This is not a leap year</CFIF>
</CFOUTPUT>
...


1