Week

Returns the ordinal for the week number in a year; an integer ranging from 1 to 53.

See also DatePart.

Syntax

Week(date)
date

Any date/time value or string convertible to 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 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.

Examples

<!--- 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>
...



1