Saturday, March 24, 2012

Simple Conversion from String to Date

VS2005 in VB.NET

I have 2 simple textboxes (Textbox1, Textbox2) and they both have dates.

Textbox1=12/31/2006
Textbox2=12/15/2006

I need to convert these two textboxes that are in String format into Date
format and I'm not sure how. I tried this and I thought it would work, but
I get the
Conversion from string "TextBox1" to type 'Date' is not valid.
--------

Dim FromDate, ToDate As Date

FromDate = CType("TextBox1", Date)

ToDate = CType("Textbox2", Date)

Thanks and any help is greatly appreciated.it should be this:
FromDate = CType(TextBox1.Text, Date)

"Phillip Vong" <phillip_vong*at*yahoo*dot*comwrote in message
news:Ob8ePziGHHA.4712@.TK2MSFTNGP04.phx.gbl...

Quote:

Originally Posted by

VS2005 in VB.NET
>
I have 2 simple textboxes (Textbox1, Textbox2) and they both have dates.
>
Textbox1=12/31/2006
Textbox2=12/15/2006
>
I need to convert these two textboxes that are in String format into Date
format and I'm not sure how. I tried this and I thought it would work,
but I get the
Conversion from string "TextBox1" to type 'Date' is not valid.
--------
>
Dim FromDate, ToDate As Date
>
FromDate = CType("TextBox1", Date)
>
ToDate = CType("Textbox2", Date)
>
>
>
Thanks and any help is greatly appreciated.
>
>


GJH,

To make it work without ever allowing an exception I do the
following...

Dim tmpDate as DateTime = DateTime.MinValue

If (Not DateTime.TryParse(TextBox1.Text, tmpDate)) Then
' the date is not valid and the tmp value is still MinValue
Else
' the date was parsed and tmpDate has the value
End If

By doing this you can place anything into the TextBox and it will not
cause an exception.

Brennan Stehling
http://brennan.offwhite.net/blog/
GJH wrote:

Quote:

Originally Posted by

it should be this:
FromDate = CType(TextBox1.Text, Date)
>
>
>
"Phillip Vong" <phillip_vong*at*yahoo*dot*comwrote in message
news:Ob8ePziGHHA.4712@.TK2MSFTNGP04.phx.gbl...

Quote:

Originally Posted by

VS2005 in VB.NET

I have 2 simple textboxes (Textbox1, Textbox2) and they both have dates.

Textbox1=12/31/2006
Textbox2=12/15/2006

I need to convert these two textboxes that are in String format into Date
format and I'm not sure how. I tried this and I thought it would work,
but I get the
Conversion from string "TextBox1" to type 'Date' is not valid.
--------

Dim FromDate, ToDate As Date

FromDate = CType("TextBox1", Date)

ToDate = CType("Textbox2", Date)

Thanks and any help is greatly appreciated.


Or use the IsDate(MyDateString) function.

--
OHM
http://TrainingOn.net
"Brennan Stehling" <offwhite@.gmail.comwrote in message
news:1165520731.553926.162360@.j72g2000cwa.googlegr oups.com...

Quote:

Originally Posted by

GJH,
>
To make it work without ever allowing an exception I do the
following...
>
Dim tmpDate as DateTime = DateTime.MinValue
>
If (Not DateTime.TryParse(TextBox1.Text, tmpDate)) Then
' the date is not valid and the tmp value is still MinValue
Else
' the date was parsed and tmpDate has the value
End If
>
By doing this you can place anything into the TextBox and it will not
cause an exception.
>
Brennan Stehling
http://brennan.offwhite.net/blog/
>
GJH wrote:

Quote:

Originally Posted by

>it should be this:
>FromDate = CType(TextBox1.Text, Date)
>>
>>
>>
>"Phillip Vong" <phillip_vong*at*yahoo*dot*comwrote in message
>news:Ob8ePziGHHA.4712@.TK2MSFTNGP04.phx.gbl...

Quote:

Originally Posted by

VS2005 in VB.NET
>
I have 2 simple textboxes (Textbox1, Textbox2) and they both have
dates.
>
Textbox1=12/31/2006
Textbox2=12/15/2006
>
I need to convert these two textboxes that are in String format into
Date
format and I'm not sure how. I tried this and I thought it would work,
but I get the
Conversion from string "TextBox1" to type 'Date' is not valid.
--------
>
Dim FromDate, ToDate As Date
>
FromDate = CType("TextBox1", Date)
>
ToDate = CType("Textbox2", Date)
>
>
>
Thanks and any help is greatly appreciated.
>
>


>


Thanks everyone!!!

"OHM" <lkjhlkjwrote in message
news:OOPHI9jGHHA.4904@.TK2MSFTNGP04.phx.gbl...

Quote:

Originally Posted by

Or use the IsDate(MyDateString) function.
>
--
OHM
http://TrainingOn.net
>
>
"Brennan Stehling" <offwhite@.gmail.comwrote in message
news:1165520731.553926.162360@.j72g2000cwa.googlegr oups.com...

Quote:

Originally Posted by

>GJH,
>>
>To make it work without ever allowing an exception I do the
>following...
>>
>Dim tmpDate as DateTime = DateTime.MinValue
>>
>If (Not DateTime.TryParse(TextBox1.Text, tmpDate)) Then
> ' the date is not valid and the tmp value is still MinValue
>Else
> ' the date was parsed and tmpDate has the value
>End If
>>
>By doing this you can place anything into the TextBox and it will not
>cause an exception.
>>
>Brennan Stehling
>http://brennan.offwhite.net/blog/
>>
>GJH wrote:

Quote:

Originally Posted by

>>it should be this:
>>FromDate = CType(TextBox1.Text, Date)
>>>
>>>
>>>
>>"Phillip Vong" <phillip_vong*at*yahoo*dot*comwrote in message
>>news:Ob8ePziGHHA.4712@.TK2MSFTNGP04.phx.gbl...
>VS2005 in VB.NET
>>
>I have 2 simple textboxes (Textbox1, Textbox2) and they both have
>dates.
>>
>Textbox1=12/31/2006
>Textbox2=12/15/2006
>>
>I need to convert these two textboxes that are in String format into
>Date
>format and I'm not sure how. I tried this and I thought it would
>work,
>but I get the
>Conversion from string "TextBox1" to type 'Date' is not valid.
>--------
>>
>Dim FromDate, ToDate As Date
>>
>FromDate = CType("TextBox1", Date)
>>
>ToDate = CType("Textbox2", Date)
>>
>>
>>
>Thanks and any help is greatly appreciated.
>>
>>


>>


>
>

0 comments:

Post a Comment