I'm working on a project to report special projects. The data extracted contains a from and to date. The users want to put in a month or month range to determine all active projects during that month or month range, summing costs and counts.
An "active" project is defined as a project that 1)started before the month and ends during or after the month, 2) started during the month and ends during or after the month.
I know I can do this with a user exit, but I'm looking for alternatives.
Your input is greatly appreciated.
Kenneth