Datediff question

[golfinray]

On a report footer, I'm using an unbound textbox to find the number of days
from Plans Received to Plans Reviewed. =datediff("d",[plans received],[plans
reviewed]) and it is giving me zeroes where the fields are null. It doesn't
do that on any other forms. How do I get just nothing in that field if there
is nothing? Thanks a bunch!!!

 

[Jack Cannon]

Try this:

=IIf(IsNull([plans received]) Or IsNull([plans
reviewed]),"",datediff("d",[plans received],[plans reviewed]))

Jack Cannon

 

[golfinray]

That worked, thanks!

Try this:

=IIf(IsNull([plans received]) Or IsNull([plans
reviewed]),"",datediff("d",[plans received],[plans reviewed]))

Jack Cannon

On a report footer, I'm using an unbound textbox to find the number of days
from Plans Received to Plans Reviewed. =datediff("d",[plans received],[plans
reviewed]) and it is giving me zeroes where the fields are null. It doesn't
do that on any other forms. How do I get just nothing in that field if there
is nothing? Thanks a bunch!!!