Hi
i have a table of dates let's say:
1/1/2004
8/1/2004
15/1/2004
29/1/2004
5/2/2004
12/2/2004
I am searching for a way to have the minimum date and maximum date for dates seperated by one week whitout gaps between them.
which will give the following output:
1/1/2004 , 15/1/2004
29/1/2004 , 12/2/2004
Any ideas??
Could this be done with aggregates ??