Wrote a report and just cannot for the life of me figure these parens out in order for all of this to work. It is all working 'except' the lines with my ** and I can't figure out what my problem is. Anyone??

(({Members.CGRPID} like {?Health Plan} and
{Members.CPLNTP} like {?LOB}) or
isnull({Members.MBRNO}))

and

{Members.CIPACD} like {?IPA} and
not ({AUTHS.Status} like ["Cancelled","Denied"]) and

**(({AUTHS.ExpirationDate} < {@StartDefaultDate} or
**not isnull({Members.TermDate})) and

({AUTHS.ReferralType} like ["HPC","DIA"] and
isnull ({V_SupplementalDataEndServiceDate.EndServiceDate}))

or

({AUTHS.ReferralType} like ["LTC", "PAL"]) and
isnull ({AUTHS.DischargeDate}))

Good morning; Tried that addition and still not working. Thank you for your suggestion though.

Hi there-yep, I tried exactly what you put in the 2nd response and that line is still not working. It's bringing back records that the expiration date is greater than the StartDefaultDate.

Example: one record has an expiration date of 11/6/2017 and my StartDefaultDate is today 09/08/2017.

That is correct. They do not have anything in the term date. Thank you again!

What Kevlray said :)