Grouping by date - using other date ranges than in CR

[zupnik]

Hi all,

CR: 8.5
DB: Access

Is there a way to define the date range for a group and then have it displayed in a crosstab?

i.e

If I just group by date and print the section for each month then for the month of May the dates will be 5/1/05 thru 5/31/05.
My Month of June 2005 however runs from 5/29/05 thru 7/2/05.

There is a FAQ on 4-4-5 calendar but I dont know if it solves this problem.

Thanks all of you
Z.

 

[Madawc]

You could do your own formula that defined categories for your date. E.g.

 if {your.date) >= Date(2005, 29, 5) 
and {your.date) <= Date(2005, 7, 2)
then "June 2005"

Madawc Williams (East Anglia, UK)

 

[zupnik]

Madawc,

Thanks for hinting me in the correct direction.....

I actually accomplished above by creating a group by date BUT then grouping in SPECIFIED order. Thats where I put the ranges in.... also works across CR years.

Z.