How to display week of the year

[wongray]

Hello,



I need help. could someone tell me how to display the week of the year in the querry?

Example: 01/01/2011 will display as Week 1, 12/28/2011 will display as Week 52

Many Thanks
Ray

[ajetrumpet]

I don't think there is a week() function in access. have you considered using datediff()?? You might be able to get it down to a science if you can use datediff() using a 'days' parameter and a floor function of somekind, like int(). maybe something like:

int(datediff("d", "1/1/" & datepart("yyyy", date()), YOUR DATE)/7)

[Alex Motilal]

Try this in your query:
Week#: DatePart("ww",[Your Date Field])
Alex Motilal