How to format the date to show weekly intervals

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

Guest

Using Access, I can format the date for monthly intervals in a query using the following expression
"Month: Format$(
.[date],'mm yyyy')." But how do I do the same for weekly intervals? I try inputting "Week: Format$(
.[date],'ww yyyy')," but the result doesn't make sense. I would appreciate any help anyone can give me
 
I don't know what you mean by "doesn't make sense" since the expression you
suggested (with two wws) is correct and should return the week of the year.

--
Duane Hookom
MS Access MVP


Tim said:
Using Access, I can format the date for monthly intervals in a query using the following expression:
"Month: Format$(
.[date],'mm yyyy')." But how do I do the same for
Click to expand...

weekly intervals? I try inputting "Week: Format$(
.[date],'ww
yyyy')," but the result doesn't make sense. I would appreciate any help
anyone can give me.
 
Back
Top