2 Replies Latest reply on Jul 28, 2008 10:42 PM by musicmp3

    grouping by date

      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