SQL IIf not returning true value

[superfly5203]

Hello,

I have the following sql statement

IIF (CCOdate = null, DateDiff('d',CDApprovalDate, actualdef), DateDiff('d',CCOdate, actualdef)) AS finalchangeage "

The query runs and performs correctly for the false statement, but it doesn't calculate anything for the true part. Any ideas as why only half of the if statement is working?

Thanks

 

[arnelgp]

IIF (IsNull(CCOdate), ....

or

IIF (Nz(CCOdate, 0) = 0, ....

 

[superfly5203]

thanks! works great now.

 

[arnelgp]

you're welcome!