How to convert string to date

Question

I have a problem in this line of code:

Dim arrivalDate As Date = Request.Form("startDate")

the error is this: "Conversion from string "" to type 'Date' is not valid."

Look here for the answer, the issue is not with Mysql: http://stackoverflow.com/questions/8634568/convert-a-string-to-a-datetime — White Feather, Mar 13 '16 at 10:53

score 3 · Answer 1 · answered Mar 13 '16 at 10:51

3

You need to parse the string value to a date.

Dim arrivalDate As DateTime = DateTime.Parse(Request.Form("startDate"))

See the following MSDN for more details.

Also if you are unsure of the validity of the startDate value (not sure if the string is actually a valid date) you can call TryParse like so:

Dim dateValue As Date

If Date.TryParse(Request.Form("startDate"), dateValue) Then
            //Do something

answered Mar 13 '16 at 10:51

Luke Stoward

1,200
12
22

Thank you for helping. :) – jdoe1111 Mar 13 '16 at 11:19

score 2 · Accepted Answer · answered Mar 13 '16 at 11:01

use TryParse always to eliminate runtime exception

Dim arrivalDate As Date
Date.TryParse(Request.Form("startDate"), arrivalDate)

if the value of Request.Form("startDate") is not a valid date then arrivalDate will have the value of Date.MinValue So have a check before performing further operations

How to convert string to date

2 Answers2