Returns the ordinal for the month, ranging from 1 (January) to 12 (December).
Month(Date)
DatePart,
MonthAsString,
Quarter
Parameter |
Description |
---|---|
date |
A date/time object. |
Year values 0 - 29 are interpreted as 21st century dates. Year values 30 - 99 are interpreted as 20th century dates.
When passing a date/time value as a string, enclose it in quotes. Otherwise, it is interpreted as a number representation of a date/time object.
You can pass the CreateDate function or Now function as the date parameter:
#Month(CreateDate(2001, 3, 3))#
<!--- shows the value of the Month function ---> <html> <head> <title> Month Example </title> </head> <body bgcolor = silver> <H3>Month 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(yourDat"))>This is a leap year<cfelse>This is not a leap year</cfif> </cfoutput> </cfif>