Returns the ordinal for the week number in a year; an integer ranging from 1 to 53.
See also DatePart.
Week(date)
Any date/time value or string convertible to date.
Years from 0 to 29 are interpreted as 21st century values. Years 30 to 99 are interpreted as 20th century values.
When passing date as a string, make sure it is enclosed in quotes. Otherwise, it is interpreted as a number representation of a date returning undesired results.
<!--- shows the value of the Week function ---> <HTML> <HEAD> <TITLE> Week Example </TITLE> </HEAD> <BODY BGCOLOR=silver> <H3>Week 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> </CFIF> ...