String to DateTime

[koorb]

I am trying to read a line from a text file and store it in a DateTime
veritable. Below is a cut down version of my problem code (in my
actual version I am using a try and catch, and I am receiving each
line in a loop to store into the Array)

If I write the string directly into the array it works, but when I use
the line from the file it doesn't go into the DateTime veriable and I
get an error. Is there something I am missing?

Dim inputArray(2) As String
FileOpen(1, "F:/DestinationTime .txt", OpenMode.Input)
inputArray(2) = LineInput(1)
FileClose(1)

Dim temp As DateTime = CDate(inputArra y(2)) 'Problem Line

The line in the file reads:
9/14/2004 6:00:00 PM
And yes I have tired adding #s.
And I even tired Option Explicit Off

The error I get is:
An unhandled exception of type 'System.Invalid CastException' occurred
in microsoft.visua lbasic.dll

Additional information: Cast from string "9/14/2004 6:00:00 PM" to
type 'Date' is not valid.

I bet it's something dead simple.

[Lucas Tam]

koorb <ko***@raidrs.c o.uk> wrote in
news:sm******** *************** *********@4ax.c om:

The error I get is:
An unhandled exception of type 'System.Invalid CastException' occurred
in microsoft.visua lbasic.dll

Additional information: Cast from string "9/14/2004 6:00:00 PM" to
type 'Date' is not valid.

According to the documentation:

CDate recognizes date formats according to the locale setting of your
system. You must provide the day, month, and year in the correct order
for your locale, or the date may not be interpreted correctly.
I see that you're in the UK and the date you're using is in US format.
It could be that CDate is trying to convert the 9th day of the 14th
month into a valid date time - which is an invalid cast exception.

Try changing your computer to US Date Times?


--
Lucas Tam (RE********@rog ers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

[koorb]

On Tue, 31 Aug 2004 20:48:14 GMT, Lucas Tam <RE********@rog ers.com>
wrote:

koorb <ko***@raidrs.c o.uk> wrote in
news:sm******* *************** **********@4ax. com:

The error I get is:
An unhandled exception of type 'System.Invalid CastException' occurred
in microsoft.visua lbasic.dll

Additional information: Cast from string "9/14/2004 6:00:00 PM" to
type 'Date' is not valid.

According to the documentation:

CDate recognizes date formats according to the locale setting of your
system. You must provide the day, month, and year in the correct order
for your locale, or the date may not be interpreted correctly.
I see that you're in the UK and the date you're using is in US format.
It could be that CDate is trying to convert the 9th day of the 14th
month into a valid date time - which is an invalid cast exception.

Try changing your computer to US Date Times?

Thankyou, it works!
And yet when I input a DateTime veritable directly, I have to use US!

[Herfried K. Wagner [MVP]]

* koorb <ko***@raidrs.c o.uk> scripsit:

FileOpen(1, "F:/DestinationTime .txt", OpenMode.Input)

"/" -> "\".

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[Anon-E-Moose]

hi************* **@gmx.at (Herfried K. Wagner [MVP]) wrote in
news:up******** ******@TK2MSFTN GP09.phx.gbl:

* koorb <ko***@raidrs.c o.uk> scripsit:

FileOpen(1, "F:/DestinationTime .txt", OpenMode.Input)

"/" -> "\".

\ / doesn't really matter.

[Cor Ligthert]

Herfried,

"/" -> "\".

This does not give a smily with me, do you know why?

Cor

[Herfried K. Wagner [MVP]]

* "Anon-E-Moose" <an**********@y ahoo.com> scripsit:

* koorb <ko***@raidrs.c o.uk> scripsit:

FileOpen(1, "F:/DestinationTime .txt", OpenMode.Input)

"/" -> "\".

\ / doesn't really matter.

.... nevertheless on a Windows platform I would always use "\".

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[Herfried K. Wagner [MVP]]

* "Cor Ligthert" <no**********@p lanet.nl> scripsit:

"/" -> "\".

This does not give a smily with me, do you know why?

LOL!

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[Jay B. Harlow [MVP - Outlook]]

Anon,
You are correct that using "/" or "\" doesn't really matter if you follow
the rules & use System.IO.Path to parse your file paths.

However! How many people, incorrectly!, use String.LastInde xOf to find the
last "\" in a path to strip off the path from the file name. How many
people, use String.IndexOf instead of String.LastInde xOf to find "." while
looking for extensions?

Because Win32 allows either "\" or "/" for the path separator, as you
identified, is why I recommend using System.IO.Path to parse file paths
instead of rolling your own...

Note like Herfried I normally use "\", more a force of habit then
anything...

Note I am using String.LastInde xOf to include VB.InStrRev & String.IndexOf
to include VB.InStr.

Just a thought
Jay

"Anon-E-Moose" <an**********@y ahoo.com> wrote in message
news:Xn******** *************** ********@140.99 .99.130...

hi************* **@gmx.at (Herfried K. Wagner [MVP]) wrote in
news:up******** ******@TK2MSFTN GP09.phx.gbl:

* koorb <ko***@raidrs.c o.uk> scripsit:

FileOpen(1, "F:/DestinationTime .txt", OpenMode.Input)

"/" -> "\".

\ / doesn't really matter.

[Devdex Developer]

Use FormatDateTime( "ur date parameters", DateFormat.Gene ralDate)
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!