Formatting "ww" question

B

Big Dog

I'm using the Format command ("ww") to return the week number for a date and
I'd like to have a leading zero for single digit week numbers so they sort
correctly. Can't figure it out - help appreciated.

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with InStr in a query 2
DatePart Expression 1
Convert week "number" to actual number to sort it in column headin 2
Date Query 1
Weekly Report 2
Display weeks from a Milestone 0
Want the week number of a given date 5
Crosstab Query by Week with Dates as Headers 5

Top