multiple criteria formula need help with

[jedder18]

scenario

clients who <= {@enddate}
clients have null value for @dischdate

or

clients who <= {@enddate}
client have value in @dischdate between @startdate and @enddate

I need clients who fit either scenario to show on report



Help Please!



Jedder

 

[BobSuruncle]

Try this:

(
   IsNull( {YourTable.DischargeDate} ) 
AND 
   {YourTable.SomeClientDate} <= {?YourEndDateParameter}
)
OR
(
   {YourTable.SomeClientDate} <= {?YourEndDateParameter}
AND
   {YourTable.DischargeDate} in {?YourStartDateParameter} to {?YourEndDateParameter}
)

Bob Suruncle