How do I get the difference between two dates that are entered on.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mwdmanjg - 05 Jan 2005 18:32 GMT

I have two date inputs on a form and i need to calculate the difference
between the two dates and display it on the same form. I have a code, but
don't know where to put it and have it display the result on the form.
Thanks in advance.

Reply to this Message

John Vinson - 05 Jan 2005 20:44 GMT

>I have two date inputs on a form and i need to calculate the difference
>between the two dates and display it on the same form. I have a code, but
>don't know where to put it and have it display the result on the form.
>Thanks in advance.

Put a textbox on the FOrm and set its Control Source property to

=DateDiff("d", [FirstDate], [SecondDate])

to get the difference in days. DateDiff will give you a choice of any
unit from seconds to years - see the online help for details.

John W. Vinson[MVP]

Reply to this Message