zero days instead of#error

[Dave Elliott]

here is my formula, but when the form is openes it shows #error instead of
the value, how can I make it show zero when a difference does not exist?
=DateDiff("d",[StartDte],[Text463])

 

[Ofer]

Try this
=iif (isnull([StartDte]) or
isnull([Text463]),0,DateDiff("d",[StartDte],[Text463])

 

[Denis Bisson via AccessMonster.com]

First question: Is [Text463] a Date/Time field?

I just tested one of my apps with your expression (using my date fields)
and it is working fine.
Cheers!
Denis

 

[Klatuu]

[Text463] is probably not being seen as a date. I would test for that and
convert it to a date.

Try this
=iif (isnull([StartDte]) or
isnull([Text463]),0,DateDiff("d",[StartDte],[Text463])

here is my formula, but when the form is openes it shows #error instead of
the value, how can I make it show zero when a difference does not exist?
=DateDiff("d",[StartDte],[Text463])