Hmmm... That is a bit more difficult.
Try this:
- Don't link the spreadsheet with the dates.
- Set the filter so that the client start date is between the start and end date parameters.
- Manually edit the selection filter to create a link between the client data and the dates. This will look something like this:
({excel.date_field} >= {client.start_date} and
{excel.date_field} <= {client.end_date})
I haven't tested this to verify it will work, but I think it will.
-Dell