Returns the ordinal for the month, ranging from 1 (January) to 12 (December).
See also DatePart, MonthAsString, and Quarter.
Month(Date)
Any date.
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.
<!--- 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> ...