Formatting "ww" question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
Convert week "number" to actual number to sort it in column headin 2
Sum query 5
Want the week number of a given date 5
Crosstab Query by Week with Dates as Headers 5
week (WW) conversion to date in Access Graph 2
Converting date to Week number 2
Week Number 3

Back
Top