Converting Date string to DateTime Format vb.net

Question

I have this example and it gives me exception "Conversion from string x to dateTime is invalid"

here is my method to validate Datetime.

Example Date string : "27/03/1985"

Public Function validateDateColumn(ByRef FieldName As String) As Boolean

    Try
        If IsDate(FieldName) Then
            Dim actualDate As DateTime = CDate(FieldName)
            Dim DtLicExp As DateTime = CDate(actualDate.ToString("d", Thread.CurrentThread.CurrentCulture))
            FieldName = DtLicExp.ToString("MM/dd/yyyy")
            Return True
        End If
    Catch ex As Exception
        'FieldName &= "Format must be MM/dd/yyyy"
        Return False
    End Try

End Function

any idea to validate this date string formate to datetime.

I want to convert this date "27/03/1985" to datetime.

I'm using asp.net with vb.net.

Why don't you use DateTime.TryParse : msdn.microsoft.com/en-us/library/9h21f14e.aspx — Madhur Ahuja
– Madhur Ahuja, Commented Dec 1, 2010 at 18:52
I wannt to convert Date like that "27/03/1985" starts with days to datetime. — Amr Elnashar
– Amr Elnashar, Commented Dec 1, 2010 at 19:09

Adriaan Stander · Accepted Answer · 2010-12-01 18:52:44Z

7

Have a look at using DateTime.TryParseExact Method or DateTime.ParseExact Method

answered Dec 1, 2010 at 18:52

Adriaan Stander

167k32 gold badges294 silver badges288 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

spolto · Accepted Answer · 2010-12-02 11:40:03Z

1

This implementation will parse dates of the format dd/MM/yyyy and update the date string to the MM/dd/yyyy as you require. DateTime.TryParseExact allows you to specify the format of the date that you need to parse.

Public Function validateDateColumn(ByRef FieldName As String) As Boolean

  validateDateColumn = False

  Dim dateValue As DateTime

  if DateTime.TryParseExact(FieldName, _
      "dd/MM/yyyy", CultureInfo.InvariantCulture, _
      DateTimeStyles.None, dateValue) Then

      validateDateColumn = True
      FieldName = dateValue.ToString("MM/dd/yyyy")
  End If

End Function

edited Dec 2, 2010 at 11:40

answered Dec 1, 2010 at 18:55

spolto

4,5614 gold badges29 silver badges34 bronze badges

Comments

Joel Etherton · Accepted Answer · 2010-12-01 18:53:50Z

0

You could try the TryParse method.

Dim myDateString as String = "7/7/2010"
Dim myDate as DateTime
Dim isDate As Boolean = DateTime.TryParse(myDateString, myDate)

If isDate Then
    ' Yay I'm a real date
End If

answered Dec 1, 2010 at 18:53

Joel Etherton

37.5k10 gold badges92 silver badges106 bronze badges

Collectives™ on Stack Overflow

Converting Date string to DateTime Format vb.net

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related