DateAdd function

[deadhead7]

I need to get the total yrs, months, days from a beginning date and ending date. EX:
Begdte:1/1/03
Enddte:2/4/04

should get something like 1yr 1month and 4days

 

[CajunCenturion]

Check out the DateDiff function in the Help files.

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[jrbarnett]

Hello

Use the DateDiff function to "subtract" one date from another. DateAdd is for adding a specified period to an existing date or time variable.

John

 

[deadhead7]

Yes use the DateDiff function. But how do I get my results.

 

[deadhead7]

HELP

 

[BobJacksonNCI]

If you're working on a form, you just need to set the "data" property of the control where you want the results.

Check out thread181-668936 for more information.

Uh, jrbarnett, you can use negative numbers with DateAdd to effect a subtraction.

HTH,
Bob

 

[jrbarnett]

Deadhead7

Follow CajunCenturion's advice and look up the DateDiff function in the helpfile, then write expressions appropriate to your situation.
Easiest way to get the help up: go into the VBA editor, type
DateDiff (
then use the tooltips to fill in variables or press F1 to load up the context sensitive help.

John

 

[gol4]

Check Out this link. microsoft has good function for this

http://support.microsoft.com/default.aspx?scid=kb;en-us;210604&Product=acc