Using a "Date" data item in a report

paulobc

I'm trying to find out if it's possible to use a "date" data item in a report to list the records in a table according to the "Period type"; "Period Start" and "Period End" filled in the request form.

Based on this information on "Period type"( could be year, month, week) it would display:

If month would be for the "period type" and "Period Start" 01.01.08 and "Period End" then it would show something like this:

january record 1
january record 2
February record 3


Thanks.

SofDaniel

What about creating a request form where the user could select the period type, and two dates (BegDate, EndDate).
Then filter the date data item according this two dates :

Period Start >= BegDate and Period End <= EndDate