DateTime difference using TimeSpan

[Guest]

I want to use TimeSpan to determine the differences between two date to
include time. My input data is in the following format:

12/25/2004 12:23:00 AM or 01/05/2005 11:59:00 PM

How do I get TimeSpan to accept my input?

How do I get the difference between two dates using TimeSpan?

I want to have the results expressed in days, hours, minutes and seconds.

 

[Lucas Tam]

How do I get TimeSpan to accept my input?

How do I get the difference between two dates using TimeSpan?

You might need to Cdate your string date/times to be accepted as a valid
time format.

You can use DateDiff to get the difference betwen two dates. The results
will be returned as a TimeInterval which has several properties to get the
minutes, hours, days.

 

[Guest]

how can I get the results from "DateDiff" to show all minutes?

Thanks

 

[Lucas Tam]

how can I get the results from "DateDiff" to show all minutes?

http://msdn.microsoft.com/library/default.asp?url=/library/en-
us/cpref/html/frlrfSystemTimeSpanClassTopic.asp


You would use the TotalMinutes property.

 

[Dennis Powell]

Try it this way:
' Create two valid dates
Dim dLast As Date = CDate([strDate])
Dim dNow As Date = Now

Dim iTime As TimeSpan = dNow.Subtract(dLast)

iTime.Minutes returns the minutes of the TimeSpan object.

Hope this helps,
Dennis

 

[Guest]

This what I've been looking for and trying to do.

Thanks

Try it this way:
' Create two valid dates
Dim dLast As Date = CDate([strDate])
Dim dNow As Date = Now

Dim iTime As TimeSpan = dNow.Subtract(dLast)

iTime.Minutes returns the minutes of the TimeSpan object.

Hope this helps,
Dennis

I want to use TimeSpan to determine the differences between two date to
include time. My input data is in the following format:

12/25/2004 12:23:00 AM or 01/05/2005 11:59:00 PM

How do I get TimeSpan to accept my input?

How do I get the difference between two dates using TimeSpan?

I want to have the results expressed in days, hours, minutes and seconds.