We recently went to ADP Enterprise, Reportsmith 4.0 - SQL:
I need tips on how to extract date ranges. My example is a Medical Benefit effective 1/13/05 through 5/31/06. Using the effective dating options of this ReportSmith, I haven't been able to grab this person if I just want to know who had the benefit for date range 8/1/05 through 8/31/05. I want a field or formula that captures them if they are "included" in my selected date range. Any ideas?
I appreciate any input.
I need tips on how to extract date ranges. My example is a Medical Benefit effective 1/13/05 through 5/31/06. Using the effective dating options of this ReportSmith, I haven't been able to grab this person if I just want to know who had the benefit for date range 8/1/05 through 8/31/05. I want a field or formula that captures them if they are "included" in my selected date range. Any ideas?
I appreciate any input.