Conversion from string to type 'date' is not valid.

Question

0.00/5 (No votes)

See more:

Need help the string value come from a textbox.
i cannot use datetimepicker because the textbox consist of other value..

What I have tried:

If ItemBox1.Text <> "" Then
           I1 = "20" & Mid(ItemBox1.Text, 16, 4) & "01"
           Dim I1Date As DateTime = DateTime.ParseExact(I1, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture)
           Dim dayApart As TimeSpan = Today.Subtract(I1Date)
           Dim diff As Double = dayApart.TotalDays
           If diff > expiryDate.Text Then
               lblmessage.Text = "*"
           Else
               'do nothing'
           End If
           'do nothing'
       End If

Posted 5-Oct-17 18:23pm

3Newbie97Programmer

Updated 5-Oct-17 20:55pm

Add a Solution

2 solutions

Solution 1

Use TryParseExact instead of ParseExact - it returns a boolean value indicating that the parse was ok or bad. If it's bad, report the problem to the user so they can correct it and do not continue.

You should never rely on users to get it right: they make typing mistakes all the time, just like you and I do.

Posted 5-Oct-17 20:01pm

OriginalGriff

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Atlapure Ambrish · Accepted Answer · 2017-10-05T20:55:00

You should use Date.TryParseExact, below is an example.

Dim enUS As New CultureInfo("en-US") 
      Dim dateString As String
      Dim dateValue As Date

      ' Parse date with no style flags.
      dateString = "20091223"
      If Date.TryParseExact(dateString, "yyyyMMdd", enUS, _
                            DateTimeStyles.None, dateValue) Then
         Console.WriteLine("Converted '{0}' to {1} ({2}).", dateString, dateValue, _
                           dateValue.Kind)
      Else
         Console.WriteLine("'{0}' is not in an acceptable format.", dateString)
      End If

Refer this for more details.