String to date

[David Gacek]

I've tried several different ways all with the same reults. Invalid date

Dim ddate As String

ddate = "11/22/2004"

Dim TryToConvert As Date = Date.Parse(ddat e)

Dim TryToConvert2 As Date = Convert.ToDateT ime(ddate)

MsgBox(CDate(dd ate) & TryToConvert & " " & TryToConvert2)

[Lucas Tam]

"David Gacek" <so*****@hotmai l.com> wrote in news:uTyL3#F0EH A.3468
@TK2MSFTNGP14.p hx.gbl:

I've tried several different ways all with the same reults. Invalid date

Dim ddate As String

ddate = "11/22/2004"

Dim TryToConvert As Date = Date.Parse(ddat e)

Dim TryToConvert2 As Date = Convert.ToDateT ime(ddate)

MsgBox(CDate(dd ate) & TryToConvert & " " & TryToConvert2)

Try TryToConvert = CDate("11/22/2004") That should work.

http://msdn.microsoft.com/library/de...l=/library/en-
us/vblr7/html/vagrptypeconver sion.asp
--
Lucas Tam (RE********@rog ers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

[Cor Ligthert]

Lucas,

For people who are Googling this newsgroup and find your sample,

Try TryToConvert = CDate("11/22/2004") That should work

Try TryToConvert = CDate("11/22/2004") That should work in the USA

A better sample can be
\\\
Dim mydate As String = New Date(2004, 11, 22).ToString
Dim TryToConvert As Date = CDate(mydate)
///

The last just an idea,

Cor

[Shiva]

How about DateTime.ParseE xact() ?

"David Gacek" <so*****@hotmai l.com> wrote in message
news:uT******** ******@TK2MSFTN GP14.phx.gbl...
I've tried several different ways all with the same reults. Invalid date

Dim ddate As String

ddate = "11/22/2004"

Dim TryToConvert As Date = Date.Parse(ddat e)

Dim TryToConvert2 As Date = Convert.ToDateT ime(ddate)

MsgBox(CDate(dd ate) & TryToConvert & " " & TryToConvert2)

[David Gacek]

Can you please provide me with a working example
as you can see this code didn't work either
Dim ddate As String

ddate = "11/22/2004"

Dim TryToConvert As Date

MsgBox(TryToCon vert = CDate("11/22/2004"))

"Lucas Tam" <RE********@rog ers.com> wrote in message
news:Xn******** *************** ****@140.99.99. 130...

"David Gacek" <so*****@hotmai l.com> wrote in news:uTyL3#F0EH A.3468
@TK2MSFTNGP14.p hx.gbl:

I've tried several different ways all with the same reults. Invalid date

Dim ddate As String

ddate = "11/22/2004"

Dim TryToConvert As Date = Date.Parse(ddat e)

Dim TryToConvert2 As Date = Convert.ToDateT ime(ddate)

MsgBox(CDate(dd ate) & TryToConvert & " " & TryToConvert2)

Try TryToConvert = CDate("11/22/2004") That should work.

http://msdn.microsoft.com/library/de...l=/library/en-
us/vblr7/html/vagrptypeconver sion.asp
--
Lucas Tam (RE********@rog ers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

[Cor Ligthert]

Shiva,

How about DateTime.ParseE xact() ?
That you can use with your sample:

When it is a field from a textbox, than you have to be absolute sure that
your program only is used in a USA datetime format zone, by instance for
Canada that is not sure.

When it is in a document or webpage when you are 100% sure that it is
returned from the zone above.

I hope this helps?

Cor

"Shiva" <sh******@onlin e.excite.com>
How about DateTime.ParseE xact() ?

"David Gacek" <so*****@hotmai l.com> wrote in message
news:uT******** ******@TK2MSFTN GP14.phx.gbl...
I've tried several different ways all with the same reults. Invalid date

Dim ddate As String

ddate = "11/22/2004"

Dim TryToConvert As Date = Date.Parse(ddat e)

Dim TryToConvert2 As Date = Convert.ToDateT ime(ddate)

MsgBox(CDate(dd ate) & TryToConvert & " " & TryToConvert2)

[David Gacek]

DateTime.ParseE xac can i use that in any time zone ? and how can i use it to
return the date in mmddyyyy format Month/Day/Year ?



"Cor Ligthert" <no************ @planet.nl> wrote in message
news:O6******** ******@tk2msftn gp13.phx.gbl...

Shiva,

How about DateTime.ParseE xact() ?

That you can use with your sample:

When it is a field from a textbox, than you have to be absolute sure that
your program only is used in a USA datetime format zone, by instance for
Canada that is not sure.

When it is in a document or webpage when you are 100% sure that it is
returned from the zone above.

I hope this helps?

Cor

"Shiva" <sh******@onlin e.excite.com>

How about DateTime.ParseE xact() ?

"David Gacek" <so*****@hotmai l.com> wrote in message
news:uT******** ******@TK2MSFTN GP14.phx.gbl...
I've tried several different ways all with the same reults. Invalid date

Dim ddate As String

ddate = "11/22/2004"

Dim TryToConvert As Date = Date.Parse(ddat e)

Dim TryToConvert2 As Date = Convert.ToDateT ime(ddate)

MsgBox(CDate(dd ate) & TryToConvert & " " & TryToConvert2)

[Lucas Tam]

"David Gacek" <so*****@hotmai l.com> wrote in
news:uV******** ******@TK2MSFTN GP11.phx.gbl:

Can you please provide me with a working example
as you can see this code didn't work either
Dim ddate As String

ddate = "11/22/2004"

Dim TryToConvert As Date

MsgBox(TryToCon vert = CDate("11/22/2004"))

Works A-OK on my side...
Dim DateString As String = "11/22/2004"
Dim TestDate As Date = CDate(DateStrin g)
MsgBox(TestDate )

I don't know what's wrong with your development environment. What error
did you get?

Are you in the UK? Possibly CDate is trying to convert your US Date into
a UK date - which would make it an invalid date.

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

[Shiva]

ParseExact() basically lets you specify the date/time format to expect when
parsing the string value.

For example, DateTime.ParseE xact ("2004/11/22", "yyyy/MM/dd", null) will get
you a DateTime value with correct date value interpretations . And
DateTime.ParseE xact ("2004/11/22", "yyyy/MM/dd", null).ToString
("MM/dd/yyyy") returns the value in the specified format - "11/22/2004".

Hope this is what you are looking for.

"David Gacek" <so*****@hotmai l.com> wrote in message
news:e1******** ******@TK2MSFTN GP09.phx.gbl...
DateTime.ParseE xac can i use that in any time zone ? and how can i use it to
return the date in mmddyyyy format Month/Day/Year ?



"Cor Ligthert" <no************ @planet.nl> wrote in message
news:O6******** ******@tk2msftn gp13.phx.gbl...

Shiva,

How about DateTime.ParseE xact() ?

That you can use with your sample:

When it is a field from a textbox, than you have to be absolute sure that
your program only is used in a USA datetime format zone, by instance for
Canada that is not sure.

When it is in a document or webpage when you are 100% sure that it is
returned from the zone above.

I hope this helps?

Cor

"Shiva" <sh******@onlin e.excite.com>

How about DateTime.ParseE xact() ?

"David Gacek" <so*****@hotmai l.com> wrote in message
news:uT******** ******@TK2MSFTN GP14.phx.gbl...
I've tried several different ways all with the same reults. Invalid date

Dim ddate As String

ddate = "11/22/2004"

Dim TryToConvert As Date = Date.Parse(ddat e)

Dim TryToConvert2 As Date = Convert.ToDateT ime(ddate)

MsgBox(CDate(dd ate) & TryToConvert & " " & TryToConvert2)

[Shiva]

Cor,

DateTime.ParseE xact() lets you specifiy the format that the date/time string
value is exepcted to be in. If you, for example, have the string as
2004/10/20, you can tell DateTime to interpret it as "yyyy/MM/dd" and you
get the correct day, month and year values.

Of course, an exception is raised if the specified string value is not as
per the given format.

"Cor Ligthert" <no************ @planet.nl> wrote in message
news:O6******** ******@tk2msftn gp13.phx.gbl...
Shiva,

How about DateTime.ParseE xact() ?
That you can use with your sample:

When it is a field from a textbox, than you have to be absolute sure that
your program only is used in a USA datetime format zone, by instance for
Canada that is not sure.

When it is in a document or webpage when you are 100% sure that it is
returned from the zone above.

I hope this helps?

Cor

"Shiva" <sh******@onlin e.excite.com>
How about DateTime.ParseE xact() ?

"David Gacek" <so*****@hotmai l.com> wrote in message
news:uT******** ******@TK2MSFTN GP14.phx.gbl...
I've tried several different ways all with the same reults. Invalid date

Dim ddate As String

ddate = "11/22/2004"

Dim TryToConvert As Date = Date.Parse(ddat e)

Dim TryToConvert2 As Date = Convert.ToDateT ime(ddate)

MsgBox(CDate(dd ate) & TryToConvert & " " & TryToConvert2)