DISPLAY DATE AS WEEK OF THE YEAR

[gneff]

I have a request from an employee to display a date as a numbered week of the year ie: 01/01/03 =1 01/02/03 = 5. I would be very appreciative if anyone has the code to do this. Many thanks in advance.

 

[67peshawar294]

gneff,
An unbound text box with:
=Format$(Date(),"ww&quot
should do it. Or "Date()" can be replaced with your datefield.
jim

 

[dakota81]

Some other alternate approaches could be:

= ([DateValue] - DateSerial(Year([DateValue]), 1, 1)) / 7

= DateDiff("w", [DateValue], DateSerial(Year([DateValue]), 1, 1))

Note: i've never used the datediff command, just read examples on this forum, so the usage may not be exact, but I know it can be worked to give what you're looking for.

 

[gneff]

Thanks all I had to do was us an existing report and change the format of the date field to ww , worked great. Thanks for the quick response