How to setup a report to show start/end dates

[cdr-dev]

I am not sure what would be the best way to set this up.

I have a relatively simple Oncall schedule database that has 5 fields:

-Name

-Specialty

-Beeper

-Start Date

-End Date

I'd like to be able to create a report that would show the dates inbetween the Start Date and End Dates. So if they enter 2/28/05 for start date and 3/4/05 for a end date, it shows them scheduled for 2/28, 3/1, 3/2, etc...

This may not be the right forum for this and I apologize if it isn't but since this is strictly a report type thing, I though this might be the appropriate place to post.

Thanks for your help!

Chris

[-Queue-]

Use two global date fields, gStartDate and gEndDate, to hold the user's selections. Create a relationship where gStartDate <= StartDate AND gEndDate >= EndDate. Use a portal based on this relationship to display the records that fall within the date range.