Calculate date differences

's Computer Specifications

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.

's Computer Specifications

Alberto Uttranadhie wrote:

>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....iff2Dates.html
--
Marsh
MVP [MS Access]

's Computer Specifications

Thanks a lot!
"Marshall Barton" <(E-Mail Removed)> escribió en el mensaje
news:(E-Mail Removed)...
> Alberto Uttranadhie wrote:
>
> >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....iff2Dates.html
> --
> Marsh
> MVP [MS Access]

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How does one calculate date differences in Outlook - calendar?	cjones@jmwlaw	Microsoft Outlook Calendar	1	2nd Apr 2008 02:32 AM
calculate date differences and give popup box	=?Utf-8?B?V2F5bmU=?=	Microsoft Outlook Form Programming	1	6th Oct 2005 03:57 AM
How to calculate Date & Time differences	robs	Microsoft Excel Discussion	8	6th Oct 2005 02:53 AM
How to calculate Date & Time differences	robs	Microsoft Excel Worksheet Functions	2	4th Oct 2005 04:22 PM
calculate date differences in years and months	=?Utf-8?B?Sm95Y2U=?=	Microsoft Excel Worksheet Functions	1	14th Mar 2005 05:18 PM