revvinghigh
Programmer
Is there a function to see differences between 2 datetime values?
thanks!
thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
help on datetime
- Thread starter revvinghigh
- Start date
- Status
mkrausnick
Programmer
Jim's answer gives you the number of seconds between two datetime values. You will have to divide by 86400 to get the number of days, and some more complicated math if you want the number of weeks or months between two datetime values. There's probably a already thread with a routine - so do a keyword search.
Mike Krausnick
Dublin, California
Mike Krausnick
Dublin, California
craigsboyd
IS-IT--Management
You may well find the following threads helpful:
How many hours to go? thread184-656586
finding day hour and minutes? thread184-720166
...I found them using the forum's keyword search, there may be more, but I think these should probably get you where you want to go on this problem.
[sub]craig1442@mchsi.com[/sub][sup]
How many hours to go? thread184-656586
finding day hour and minutes? thread184-720166
...I found them using the forum's keyword search, there may be more, but I think these should probably get you where you want to go on this problem.
[sub]craig1442@mchsi.com[/sub][sup]
"Whom computers would destroy, they must first drive mad." - Anon
[/sup]- Status
