Week numbers

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I am using the WW format in a query and was wondering if
there is any way to get the leading zero to display.
 
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.
Click to expand...

I reckon you could format the format:

SELECT Format(Format([YourDateField], "ww"), "00") As WeekNo ...
 
You must log in or register to reply here.

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

Week Number 2
Week numbers 2
Wrong week number 2
Week number 1
Get date for start of week 3
help getting leading zero to show 7
Week number from date 3
extracting a weeks worth of data in a query 6

Back
Top