Calculating days between two dates, even when one is blank

[KBrandon]

On my Access Form, I have two dates [StartDate], [EndDate] and another field [NoDays] that calculates the number of days between my two dates. Using DateDiff my calculation works fine, however, if I do not have an [EndDate] I want it to calculate from the [startDate] to today's date. How do I make this work?

[RuralGuy]

Use an IIF statement and Test the date with IsDate().

[Robeen]

Go to the Properties of NoDays and type this into the Control Source:

 
=IIf(IsNull([EndDate]),Date()-[StartDate],[EndDate]-[StartDate])

[KBrandon]

Go to the Properties of NoDays and type this into the Control Source:

 
=IIf(IsNull([EndDate]),Date()-[StartDate],[EndDate]-[StartDate])

Thanks!! It worked perfectly....YOU ROCK!!

[Robeen]

I'm happy that I could help. All the best!