"The ) is missing" is driving me nuts

[Rich24]

I keep getting the "The ) is missing" error message with the following formula:

{mhserv.sercod} = "IS024" and
((not isnull {mhprognew.opendat1}) and
(isnull {mhprognew.closedat1})) or
((not isnull {mhprognew.opendat2}) and
(isnull {mhprognew.closedat2})) or
((not isnull {mhprognew.opendat3}) and
(isnull {mhprognew.closedat3}))

I probably went overboard the parenthesis', but the number of opening and closing parenthesis do match. What I'm trying to find is any client with an opening date and no closing date. Is my problem somewhere in that logic?

Thanks, Rich

 

[lbass]

For one thing, you have no open paren after "is null" in each line. Try:

{mhserv.sercod} = "IS024" and
(
(
not isnull ({mhprognew.opendat1}) and
isnull ({mhprognew.closedat1})
) or
(
not isnull ({mhprognew.opendat2}) and
isnull ({mhprognew.closedat2})
) or
(
not isnull ({mhprognew.opendat3}) and
isnull ({mhprognew.closedat3})
)
)

-LB

 

[Rich24]

LB,

That did the trick. Thank you very much!

Rich