If, then, else on Null values

[Debnla]

My syntax :
if {vInvoiceHeaderWithAdj_DH.AdjType} = 501 then {vInvoiceHeaderWithAdj_DH.adjDate} else {vInvoiceHeaderWithAdj_DH.TranDate}

AdjType contains 501, 502 and nulls.
I want the results to show TranDate if AdjType is 502 OR if it contains nulls.

My current results only returns the correct date on the AdjType value that is NOT a null. If AdjType is null, I get no date. This is wrong. It should show TranDate if it is null.

How can I fix this?

Thanks in advance.

 

[dgillz]

If isnull({YourField}) then <true logic> else <false logic>

Always put the null test first.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[Debnla]

If isnull({vInvoiceHeaderWithAdj_DH.AdjType}) then {vInvoiceHeaderWithAdj_DH.TranDate} else
if {vInvoiceHeaderWithAdj_DH.AdjType} = 501 then {vInvoiceHeaderWithAdj_DH.adjDate} else
{vInvoiceHeaderWithAdj_DH.TranDate}

It worked like a champ. Thanks so much!