Estimated time between dates

[lloydmav]

I have a tricky problem

I have a series of fields on a form. Date Entered, Deadline and Estimated Time. The Date Entered and the Deadline will both be date inputs by the user. What I want is that when a user inputs these dates the estimated time is then calculated between the two dates.

So how do I calculate the estimated time between dates eg 20/11/02 and 26/01/03?

If this is possible, with the solution what difference would it make if the date was then say 20/11/2002 and 26/01/2003

Thanks for any help

 

[ColinEssex]

Do a DateDiff in the properties of the 2nd date field.

Col

 

[indesisiv]

can u use

Me.txtdiff = DateDiff("d", [Date Entered], [Deadline])

would give you number of days...
you can use "y" for years ... etc

 

[lloydmav]

Cheers indesisiv, works perfect!

Cheers for the help guys