Week numbers

Dave · Oct 7, 2004

I am using the WW format in a query and was wondering if
there is any way to get the leading zero to display.

Dirk Goldgar · Oct 7, 2004

Dave said:
I am using the WW format in a query and was wondering if
there is any way to get the leading zero to display.

I reckon you could format the format:

SELECT Format(Format([YourDateField], "ww"), "00") As WeekNo ...