Convert mm/dd/yy to calendar week number

[briansmithdanisco]

Hi all,

I did a search and could not find anything that matched.

Does anyone know how to convert a date to return the week number of the year.

Example:
Input 1/14/08 and get back week 3.
Input 2/26/08 and get back week 9.

 

[HarleyQuinn]

Something like:

DatePart("WW",YourDate)

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[briansmithdanisco]

Hi HarleyQuinn,

It worked. Thanks. I could ot find anything that matched. Simple and short. Just what I was looking for.

Thanks again.

 

[HarleyQuinn]

Glad I could help

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.