(isnull({Po_noteExtensionBase.Po_ReissueDate}) and
not isnull({Po_noteExtensionBase.Po_RenewalNote}) and
cdate({Po_noteExtensionBase.Po_EffectiveDate}) <= date(currentdate + time(23,59,59)) and
date({Po_noteExtensionBase.Po_EffectiveDate})<>date({Po_noteExtensionBase.Po_ActualRedemptionDate})
and {Po_noteBase.statecode}=0))
or
(isnull({Po_noteExtensionBase.Po_ReissueDate}) and
not isnull({Po_noteExtensionBase.Po_RenewalNote}) and
cdate({Po_noteExtensionBase.Po_EffectiveDate}) <= date(currentdate + time(23,59,59)) and
isnull({Po_noteExtensionBase.Po_ActualRedemptionDate}) and not isnull({Po_noteExtensionBase.Po_EffectiveDate})
and {Po_noteBase.statecode}=0))

 

I must be doing something wrong though becase it does not like anything starting with the or.

 

Could anyone tell me why?

 

Thanks!

 

Dale