Following your logic for #1, wouldn't both Request 1 and Request 3 be shown? I don't have time today to look at #2, but take a look at the attached sheet and see if it gets you any closer.
test group.qvw 154.2 K
Thanks for your swift response!
I've been trying to work with the sheet you attached and am still having trouble. Also, I may have not been as clear as I would have liked in the instructions...Request 1 should not be shown because it did not have an appointment date.
My primary confusions surrounds what this part of the fuction is supposed to do:
(VisitDate>(RequestDate+3) or VisitDate<(RequestDate+3) or IsNull(RequestDate))
I tried to iterate on your expression, and this got me a little closer to the answer, but i'm still scrambling a bit! :-) On change I made is to make the look-up date for the data the Request Date (01/01/2013) rather than Today (01/07/2013):
([Processing Date]<>0 or [Processing Date]<>'')
([Appointment Date]<>0 or [Appointment Date]<>'')
(IsNull [Complete Date]=-1 or [Complete Date]=''),1)
Thanks again, Rob