Date and Time [ http://www.andreavb.com/forum/viewtopic.php?TopicID=4528 ]

jaytyah
26-02-2005 at 08:01 AM

Date and Time

Ive been trying to do a module that would take 2 dates and times as input and give a result of their difference in seconds. Maximum difference would only be 2 days (172,800 secs).

Example:
Input 1: Feb 23, 2005. 11:30 AM
Input 2: Feb 24, 2005. 11:31 AM

Result: 86460 secs.

Ive been trying for 2 days now and im failing miserably.

Could you please help me out with this?

Goran
26-02-2005 at 12:54 PM

Re: Date and Time

DateDiff Function

Here is the explanation of DateDiff function taken from MSDN, you also have a link to example on the top of the page. Since this is a very often question, it will be moved to Frequently asked questions section.

____________________________
If you find the answer helpful, please mark this topic as solved.