Why is this IIF logic not working ?!

[AlexT]

Folks,

I have a report with the detail section containing an unbound field
with the following calculation

=IIf([objDate]=0, "nothing", "Date : " &
Format([objDateSortie],"mm-yyyy"))

For some reason the field either prints

"Date :" when objDate = 0
"Date : xx-yyyy" when objDate > 0

Altough the latter is what I would expect I'm at loss to understand the
former... How should I print out "nothing" when objDate = 0 ?!

Thanks for your time

--alexT

 

[Rick B]

What kind of field is objDate? Is it ever equal to zero?

 

[Duane Hookom]

Do you actually store 0 in the field objDate? Is it possible that objDate is
Null? If so, try:
=IIf(IsNull([objDate]), "nothing", "Date : " &
Format([objDateSortie],"mm-yyyy"))

 

[AlexT]

Do you actually store 0 in the field objDate?

Is it possible that objDate is Null?

Good point ! That was the trick !



Thanks

--alexT