PC Review


Reply
Thread Tools Rate Thread

Calculate date differences

 
 
Alberto Uttranadhie
Guest
Posts: n/a
 
      5th Nov 2003
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.


 
Reply With Quote
 
 
 
 
Marshall Barton
Guest
Posts: n/a
 
      5th Nov 2003
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]
 
Reply With Quote
 
Alberto Uttranadhie
Guest
Posts: n/a
 
      5th Nov 2003
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]



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:09 PM.