I am attempting to prompt a report user, when two range of dates overlap, so corrections can be made. I am grouping on customers id then in the details, showing how long they were provided services. Sometimes the range overlaps and is not always sequential. I have tried the previous and next functions but they do not work when the overlap isn't sequential. For example
Customer XYZ
Dates of Services 05-07-2013 - 05-31-2013
06-01-2013 - 12-31-2013
08-01-2013 - 08-31-2013 [highlight #EF2929]Overlap Error[/highlight]
09-01-2013 - 02-28-2014
03-01-2014 - 08-31-2014
Both the 08-01-2013 - 08-31-2013 and 09-01-2013 - 02-28-2014 overlap into the 06-01-2013 - 12-31-2013 service dates but I can only get one of them to show using the previous function. Any suggestions. Thanks,
Customer XYZ
Dates of Services 05-07-2013 - 05-31-2013
06-01-2013 - 12-31-2013
08-01-2013 - 08-31-2013 [highlight #EF2929]Overlap Error[/highlight]
09-01-2013 - 02-28-2014
03-01-2014 - 08-31-2014
Both the 08-01-2013 - 08-31-2013 and 09-01-2013 - 02-28-2014 overlap into the 06-01-2013 - 12-31-2013 service dates but I can only get one of them to show using the previous function. Any suggestions. Thanks,