I need to group records by date range. User supply single day (or list of days) and report should show him data group by day-5days. For example user enter 14.07.2008 and 20.06.2008. In report he should see 2 groups: 09.07 to 14.07 and 15.06 to 20.06. I tried to do this by group formula:

{Date} to DateAdd("d",-5, {Date}) but i got error that value cannot be range...Any ideas how to accomplish that?

 

Greetings