Thr33of4
Sep 11 2005, 05:47 PM
I have a form that has a calculated field based on the difference between two dates. The calculation obviously errors if both date fields are not filled in. This happens upon moving to a new record where neither dates are filled in. How do I make the calculation conditional to both dates being filled in?
niesz
Sep 11 2005, 06:27 PM
=IIf(Date1 Is Not Null and Date2 Is Not Null,DateDiff("d",Date1,Date2),"")