Good Afternoon everyone,
I have the following formula behind a running total. It is not giving me the results I expect. If I use the criteria from either or clause seperately they apprear to work fine but as soon as I put the or between them they break. Can someone tell me what I am missing?
cdate ({Po_noteExtensionBase.Po_ActualRedemptionDate}) in cdate({?BeginningDateRange}) to currentdate + time(23,59,59) or
cdate ({Po_noteExtensionBase.Po_MaturityDate}) in dateadd('d',1,currentdate + time(00,00,00)) to dateadd('m',6,{?EndingDateRange}) and
not isnull({Po_noteExtensionBase.Po_NonRenewalNoticeReceived})
So what I am trying to accomplish is everthing before the or is one condition and everything after the or is another condition.