Calculating Year, Month and Day of Service

[ScottM]

Ok, I've managed to teach mysels about the DateDiff
function and I can calculate all of the above from a date
in the past [ServiceDate] and Date(). The problem I have
is, with a ServiceDate = 10/01/1994 and Date() =
09/01/2004, I get 10 years 119 Months 3624 Days.

How do I get a running count of 9 years 11 months 2 days?

TIA

 

[Jeff Conrad]

You may want to try MVP Doug Steele's more complete DateDiff function here:

http://members.rogers.com/douglas.j.steele/Diff2Dates.html

Copy and paste all the code to a new standard module, compile, and save.
From the Immediate Window.....

?Diff2Dates("ymd", #10/01/1994#, Date(), True)

...I get:

9 years 11 months 1 day

 

[Guest]

Dude, you (and Doug) are awesome!!!

Thanks

-----Original Message-----
You may want to try MVP Doug Steele's more complete DateDiff function here:

http://members.rogers.com/douglas.j.steele/Diff2Dates.html

Copy and paste all the code to a new standard module, compile, and save.
From the Immediate Window.....

?Diff2Dates("ymd", #10/01/1994#, Date(), True)

...I get:

9 years 11 months 1 day

--
Jeff Conrad
Access Junkie
Bend, Oregon

Ok, I've managed to teach mysels about the DateDiff
function and I can calculate all of the above from a date
in the past [ServiceDate] and Date(). The problem I have
is, with a ServiceDate = 10/01/1994 and Date() =
09/01/2004, I get 10 years 119 Months 3624 Days.

How do I get a running count of 9 years 11 months 2 days?

TIA

.

 

[Jeff Conrad]

Dude, you (and Doug) are awesome!!!

Thanks

You're welcome, glad to help.
Correction: Doug is awesome, I just count bottles on the wall for him.

--
Jeff Conrad
Access Junkie
Bend, Oregon

-----Original Message-----
You may want to try MVP Doug Steele's more complete DateDiff function here:

http://members.rogers.com/douglas.j.steele/Diff2Dates.html

Copy and paste all the code to a new standard module, compile, and save.
From the Immediate Window.....

?Diff2Dates("ymd", #10/01/1994#, Date(), True)

...I get:

9 years 11 months 1 day

--
Jeff Conrad
Access Junkie
Bend, Oregon

Ok, I've managed to teach mysels about the DateDiff
function and I can calculate all of the above from a date
in the past [ServiceDate] and Date(). The problem I have
is, with a ServiceDate = 10/01/1994 and Date() =
09/01/2004, I get 10 years 119 Months 3624 Days.

How do I get a running count of 9 years 11 months 2 days?

TIA

 

[Douglas J. Steele]

<g> BTW, are you aware that I have a collection of around 1200 empty beer
bottles in my basement...

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Dude, you (and Doug) are awesome!!!

Thanks

You're welcome, glad to help.
Correction: Doug is awesome, I just count bottles on the wall for him.

--
Jeff Conrad
Access Junkie
Bend, Oregon

-----Original Message-----
You may want to try MVP Doug Steele's more complete DateDiff function here:

http://members.rogers.com/douglas.j.steele/Diff2Dates.html

Copy and paste all the code to a new standard module, compile, and save.
From the Immediate Window.....

?Diff2Dates("ymd", #10/01/1994#, Date(), True)

...I get:

9 years 11 months 1 day

--
Jeff Conrad
Access Junkie
Bend, Oregon

Ok, I've managed to teach mysels about the DateDiff
function and I can calculate all of the above from a date
in the past [ServiceDate] and Date(). The problem I have
is, with a ServiceDate = 10/01/1994 and Date() =
09/01/2004, I get 10 years 119 Months 3624 Days.

How do I get a running count of 9 years 11 months 2 days?

TIA

 

[Jeff Conrad]

Yes, I know!
I keep losing count and having to start all over!!
<vbg>

And your wife lets you keep all those?
Wow, you have a very patient wife.


--
Jeff Conrad
Access Junkie
Bend, Oregon

<g> BTW, are you aware that I have a collection of around 1200 empty beer
bottles in my basement...

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Dude, you (and Doug) are awesome!!!

Thanks

You're welcome, glad to help.
Correction: Doug is awesome, I just count bottles on the wall for him.

--
Jeff Conrad
Access Junkie
Bend, Oregon

-----Original Message-----
You may want to try MVP Doug Steele's more complete
DateDiff function here:

http://members.rogers.com/douglas.j.steele/Diff2Dates.html

Copy and paste all the code to a new standard module,
compile, and save.
From the Immediate Window.....

?Diff2Dates("ymd", #10/01/1994#, Date(), True)

...I get:

9 years 11 months 1 day

--
Jeff Conrad
Access Junkie
Bend, Oregon

message
Ok, I've managed to teach mysels about the DateDiff
function and I can calculate all of the above from a
date
in the past [ServiceDate] and Date(). The problem I
have
is, with a ServiceDate = 10/01/1994 and Date() =
09/01/2004, I get 10 years 119 Months 3624 Days.

How do I get a running count of 9 years 11 months 2
days?

TIA