Calculate date differences

[Alberto Uttranadhie]

Hi, everybody,

I would like to know if there is any method to calculate
date differences and returns results in the following
format: 1 year(s), 5 month(s), 3 day(s); that is, time
passed since a given date from a control up to present
date.

I tried to use Format(Date()-Me.ctlMyDate, "y-m-d") but I
think something is wrong.

Thanks and regards,

Alberto.

 

[Marshall Barton]

I would like to know if there is any method to calculate
date differences and returns results in the following
format: 1 year(s), 5 month(s), 3 day(s); that is, time
passed since a given date from a control up to present
date.

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

 

[Alberto Uttranadhie]

Thanks a lot!

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