Compute Difference in Dates in Access

[sharathragunathan]

HI,

I have an Access novice and I have a question.I have a form that has a
request date that a user enters. What I need is when you click on a
command button, say Elapsed Time, it should give (via messge box or as
data in a text box) the difference between the request date and the
current day.

Eg : Request Date- 02/02/2003 and assuming current date is 02/02/2007
Elapsed Time - 4 years.
This information doesnt get stored in the database and needs to
execute everytime you click the command button. Also, the message must
be displayed before the rest of the information on the form is filled
out.Please let me know how to do this.

Thanks in advance

[fredg]

On 16 Feb 2007 08:08:27 -0800, sh***************@gmail.com wrote:

HI,

I have an Access novice and I have a question.I have a form that has a
request date that a user enters. What I need is when you click on a
command button, say Elapsed Time, it should give (via messge box or as
data in a text box) the difference between the request date and the
current day.

Eg : Request Date- 02/02/2003 and assuming current date is 02/02/2007
Elapsed Time - 4 years.
This information doesnt get stored in the database and needs to
execute everytime you click the command button. Also, the message must
be displayed before the rest of the information on the form is filled
out.Please let me know how to do this.

Thanks in advance

Look up the DateDiff function in VBA help.
In Years?
Code the command button click event:
MsgBox DateDiff("yyyy",[RequestDate],Date())

In Days?
MsgBox DateDiff("d",[RequestDate],Date())

or to display in a text control, add an unbound control to the form.
Set it's control source to:
= DateDiff("yyyy",[RequestDate],Date())

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail