Webmaster Forum / ColdFusion / Advanced Techniques / July 2008

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