What is the time interval between the first and second dates , how can I do it

DateDiff returns the number of days between two dates. It does not return the time between two dates with times. At least that is what I found. For example, I needed to determine if 12 hours had passed since the last time it was checked. Using DateDiff returned hours in increments of 24 (ie. 24, 48, 72, etc). I had to parse out the data/times from the two variables to determine if 12 hours had passed. Not fun. Be nice if there was another way to determine the time interval between two date/time variables.

John

Can you show the actual code you are using? To return the number of hours you should do this:

retVal = DateDiff(“h”, date1, date2)

“h” tells the function to return the result in the “exact” number of hours (not sure if it will round up or down for partial hours).

My code for determining a 12 hour elapsed time may not be what you need. If you want that I’ll put it in another post. When I have the time I’ll make a true time/date interval routine and post that as well. In the mean time the following lines of code might get you started. They are what is needed to do this:

DateTimeBegin = “9/06/2017 8:09:56 PM” 'test data

DateTimeEnd = “9/06/2017 10:02:56 PM” 'test data

daysDiff = CInt(DateDiff(“d”,DateTimeBegin,DateTimeEnd))

m1 = (CInt(Hour(DateTimeBegin)) * 60) + CInt(Minute(DateTimeBegin))

m2 = (CInt(Hour(DateTimeEnd)) * 60) + CInt(Minute(DateTimeEnd))

John

Thank you for your reply, the idea of what I want to do it its , the first date is defined and the another

Then Calculates the difference in days

If all you need is the number of days use DateDif:

daysDiff = CInt(DateDiff(“d”,DateTimeBegin,DateTimeEnd))

John