Programming Forums > Application Development > Visual Basic .NET

Illuminati · Apr 10th, 2005, 9:32 AM

Need to be able to get the amount of time inbetween 2 dates and times, im storing the date and time in a database using the DateAndTime method.

I need to be able to find out the amount of Days, hours, minutes and seconds from that date and time and the time and date of that day.

Ive tried using Datediff() but that only gave me the time between the date and not the time, can anyone help me out?

Infinite Recursion · Apr 10th, 2005, 6:12 PM

Why not use DateDiff?

(Toggle Plain Text)

Private Sub Command1_Click()
Dim lngHowLong As Long

    lngHowLong = DateDiff("s", "3/3/2002 14:22:55", Now)
    MsgBox "There are " & lngHowLong & " seconds between the date shown and now."
End Sub

Illuminati · Apr 10th, 2005, 8:40 PM

Well it didnt work before, but that appears to work, lol. thanks.

Dameon · Apr 10th, 2005, 8:50 PM

Personally, I use the built in data types DateTime and TimeSpan and their member functions for this. All you have to do is:

(Toggle Plain Text)

Now.Subtract(TheStartingDate)

..whcih returns a TimeSpan. The TimeSpan class has properties for various (read: all you could want) measurments. So if you wanted all seconds between the two times, you would write:

(Toggle Plain Text)

Now.Subtract(TheStartDate).TotalSeconds

However, There is a large difference between TotalSeconds and Seconds, and that goes for the others as well. Say you had a TImeSpan of 1 minute and 3 seconds...TotalSeconds would return 63 while Seconds would return 3.

TimeSpan has everything from years to milliseconds, so you should be covered.

Infinite Recursion · Apr 10th, 2005, 9:33 PM

You're welcome Illuminati

Apr 10th, 2005, 9:32 AM	#1
Illuminati Newbie Join Date: Apr 2005 Posts: 12 Rep Power: 0	Time between two dates and times Need to be able to get the amount of time inbetween 2 dates and times, im storing the date and time in a database using the DateAndTime method. I need to be able to find out the amount of Days, hours, minutes and seconds from that date and time and the time and date of that day. Ive tried using Datediff() but that only gave me the time between the date and not the time, can anyone help me out?

Apr 10th, 2005, 6:12 PM	#2
Infinite Recursion Programming Guru Join Date: Jul 2004 Location: United States Posts: 3,467 Rep Power: 8	Why not use DateDiff? (Toggle Plain Text) Private Sub Command1_Click() Dim lngHowLong As Long lngHowLong = DateDiff("s", "3/3/2002 14:22:55", Now) MsgBox "There are " & lngHowLong & " seconds between the date shown and now." End Sub Private Sub Command1_Click() Dim lngHowLong As Long lngHowLong = DateDiff("s", "3/3/2002 14:22:55", Now) MsgBox "There are " & lngHowLong & " seconds between the date shown and now." End Sub __________________ http://jasonpowers.net "There are a thousand hacking at the branches of evil to one who is striking at the root."

Apr 10th, 2005, 8:50 PM	#4
Dameon Troll Join Date: Apr 2005 Location: Texas Posts: 732 Rep Power: 4	Personally, I use the built in data types DateTime and TimeSpan and their member functions for this. All you have to do is: (Toggle Plain Text) Now.Subtract(TheStartingDate) Now.Subtract(TheStartingDate) ..whcih returns a TimeSpan. The TimeSpan class has properties for various (read: all you could want) measurments. So if you wanted all seconds between the two times, you would write: (Toggle Plain Text) Now.Subtract(TheStartDate).TotalSeconds Now.Subtract(TheStartDate).TotalSeconds However, There is a large difference between TotalSeconds and Seconds, and that goes for the others as well. Say you had a TImeSpan of 1 minute and 3 seconds...TotalSeconds would return 63 while Seconds would return 3. TimeSpan has everything from years to milliseconds, so you should be covered.

Apr 10th, 2005, 9:33 PM	#5
Infinite Recursion Programming Guru Join Date: Jul 2004 Location: United States Posts: 3,467 Rep Power: 8	You're welcome Illuminati __________________ http://jasonpowers.net "There are a thousand hacking at the branches of evil to one who is striking at the root."

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 10th, 2005, 8:40 PM	#3
Illuminati Newbie Join Date: Apr 2005 Posts: 12 Rep Power: 0	Well it didnt work before, but that appears to work, lol. thanks.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Programming Forums > Application Development > Visual Basic .NET

Time between two dates and times