Return week from date.

[Guest]

I need to return the week of the year from a date. The date format is
01/19/2006 and as an example using the above date, I would like to return the
week "3". I am working with DatePart. In the following example:

Week: DatePart("w",[ProductRentaltbl].[TransactionDate])

the return is the number for the day of the week. How can I get the week
numbers 1 through 52?

 

[Rick Brandt]

I need to return the week of the year from a date. The date format is
01/19/2006 and as an example using the above date, I would like to
return the week "3". I am working with DatePart. In the following
example:

Week: DatePart("w",[ProductRentaltbl].[TransactionDate])

the return is the number for the day of the week. How can I get the
week numbers 1 through 52?

"ww"

 

[Guest]

Thanks Rick!

Dennis

I need to return the week of the year from a date. The date format is
01/19/2006 and as an example using the above date, I would like to
return the week "3". I am working with DatePart. In the following
example:

Week: DatePart("w",[ProductRentaltbl].[TransactionDate])

the return is the number for the day of the week. How can I get the
week numbers 1 through 52?

"ww"