Link to home
Start Free TrialLog in
Avatar of hilltop
hilltopFlag for United States of America

asked on

Compare Dates?????

how could I take a date in the format 12/03/2000 and programatically determine how many days have past to present date.
E.G
12/03/2000 to 04/21/2002 how many days have past
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

use the DateDiff function like this:
msgbox datediff("d",#2000/03/12#,date)
ASKER CERTIFIED SOLUTION
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of KarcOrigin
KarcOrigin

Hi,

You can use it like this too:

DateDiff("d", Format("11/03/2000", "MM-DD-YYYY"), Format("12/03/2002", "MM-DD-YYYY"))

Thanks.

Avatar of hilltop

ASKER

thank you very much