Using OR in formula

[bernie321]

Hi

I have the below formula:

{DateTable.LastDate} < DateAdd ('D', (0-{?Days}), CurrentDate)
OR
ISNULL({DateTable.LastDate}) = TRUE

The ISNULL code works on its own but not in this selection formula with the date add row.

Any advice on this matter would be great.

Thanks B

 

[bdreed35]

You should always check for NULLs first as Crystal will return NULL as soon as it encounters NULL in a formula.

ISNULL({DateTable.LastDate})
OR
{DateTable.LastDate} < DateAdd ('D', (0-{?Days}), CurrentDate)

~Brian

 

[bernie321]

Thanks Brian

Its been driving me crazy I didnt think about execution order.

Cheers B