How do you filter on the results of another OTBI analysis in combination with a date prompt?

Summary:

I want to be able to split workers who are paid and unpaid and break them down by age, BU etc etc. Those who are paid may have additional assignments as non-workers so the simplest way I can think of is have one analysis that defines those who have the appropriate payroll relationship and define the unpaid people as being those who aren't in the first analysis. This seems to work with today's data but when I add a date prompt I get SQL errors. Is it possible to do this with an effective date prompt or