Using If

[kathleensfather]

I am calculating the number of days between two dates. If I at the time of data entry I don't know the second date, how do I avoid seeing the illogical number in the calculated field ?

Can I use a radio button to activate a second field ?

 

[suesloan]

Your calculated field can test the date fields to see if they are blank using the IsBlank() function:

NDays = If(IsBlank(datefld1) or IsBlank(datefld2),0,datefld2 - datefld1)

Sue Sloan

http://www.xpertss.com