Morning all!

I'm trying to format a report in CR 2008 to make overdue items have a red date. The code is below:

if
(isNull({NCR.CloseDate_CAR}) and
{NCR.ExtendDate_CAR} < CurrentDate)
xor
(isNull({NCR.CloseDate_CAR}) and
{NCR.DueDate_CAR} < CurrentDate)
then crRed else crNoColor

Basically, the formatting is to make a field's text red only if -EITHER- the NCR.CloseDate_CAR is blank and the NCR.ExtendDate_CAR is less than the current date -OR- the NCR.CloseDate_CAR is blank and the NCR.DueDate_CAR is less than the current date. What I'm getting is the text is red only if the 2nd condition is met...it ignores the first condition totally.

I'm sure I have some wrong logic in the code but I can't see where. Can anyone assist?

Thanks in advance!

Cactusman

That was worse. I changed back to exceptions and revised the formatting code for the meantime to be:

if (isNull({NCR.CloseDate_CAR}) and
{NCR.DueDate_CAR} < CurrentDate) then
crRed else crNoColor

M

Dblank, you are 100% correct!!!

Bingo! Much thanks, DBlank!!