Dear Sir/Madam


In my SQL statement my Grouping is done by Week. This is only effective when my date range is less than a year or just one year. If date range is more than a year I get two week no same which effect my calculation.

Please suggest no matter what the date range is I get a unique feild for grouping sorted by date Asc.

Please help