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.

"=?Utf-8?B?TGFycnkgQmlyZA==?=" <(E-Mail Removed)> wrote
in news:CE6405DE-CB3B-486B-AF31-(E-Mail Removed):

> 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.

--
Lucas Tam ((E-Mail Removed))
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

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

Thanks


"Lucas Tam" wrote:

> "=?Utf-8?B?TGFycnkgQmlyZA==?=" <(E-Mail Removed)> wrote
> in news:CE6405DE-CB3B-486B-AF31-(E-Mail Removed):
>
> > 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.
>
> --
> Lucas Tam ((E-Mail Removed))
> Please delete "REMOVE" from the e-mail address when replying.
> http://members.ebay.com/aboutme/coolspot18/
>

"=?Utf-8?B?TGFycnkgQmlyZA==?=" <(E-Mail Removed)>
wrote in news:C42A80DC-5B96-4585-8F56-(E-Mail Removed):

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


http://msdn.microsoft.com/library/de...l=/library/en-
us/cpref/html/frlrfSystemTimeSpanClassTopic.asp


You would use the TotalMinutes property.


--
Lucas Tam ((E-Mail Removed))
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

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


"Larry Bird" <(E-Mail Removed)> wrote in message
news:CE6405DE-CB3B-486B-AF31-(E-Mail Removed)...
> 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.

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

Thanks



"Dennis Powell" wrote:

>
> 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
>
>
> "Larry Bird" <(E-Mail Removed)> wrote in message
> news:CE6405DE-CB3B-486B-AF31-(E-Mail Removed)...
> > 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.
>
>
>