Week of Year

A

Angus Crossley

I want to sort records and report on them grouped according to the calendar
week they fall in. Is there a 'Week of Year' function or a way to calculate
this?
 
D

Duane Hookom

Try lookup Help on the DatePart() or Format() functions. You might need to
be in a code/module window to get the proper Help.
 
A

Angus Crossley

Many thanks, DatePart fits the bill perfectly.

Duane Hookom said:
Try lookup Help on the DatePart() or Format() functions. You might need to
be in a code/module window to get the proper Help.
Click to expand...
 
Top