grouping by date

["Hagster" <webforumsuser@xxxxxxxxxxxxxx>]

Hello All
 Im just about to start a new project and was woundering if any one had any 
pointers on how I can group by weeks when selecting data

 Each line of data consists of a part number and a due date for example.
 I wish to select data and group by weeks 21 / July -  27 / July  etc

 So all parts with a due date between week start and week end dates would get 
grouped up.

 Question can you group on the TSQL statment by ISO weeks etc or will this have 
to be done in the CFM code?

 Not asking for a solution here im very willing to sit and think for myself, 
just wondered on any pointers that might be around.

 Kind Regards Guy