Date

Other topics

Converting (Parsing) a String to a Date

If you know the format of the string you are converting (parsing) you should use DateTime.ParseExact

Dim dateString As String = "12.07.2003"
Dim dateFormat As String = "dd.MM.yyyy"
Dim dateValue As Date

dateValue = DateTime.ParseExact(dateString, dateFormat, Globalization.CultureInfo.InvariantCulture)

If you are not certain for the format of the string, you can use DateTime.TryParseExact and test the result to see if parsed or not:

Dim dateString As String = "23-09-2013"
Dim dateFormat As String = "dd-MM-yyyy"
Dim dateValue As Date

If DateTime.TryParseExact(dateString, dateFormat, Globalization.CultureInfo.InvariantCulture, DateTimeStyles.None, dateValue) Then
    'the parse worked and the dateValue variable now holds the datetime that was parsed as it is passing in ByRef
Else
    'the parse failed
End If

Converting a Date To A String

Simply use the .ToString overload of a DateTime object to get the format you require:

Dim dateValue As DateTime = New DateTime(2001, 03, 06)
Dim dateString As String = dateValue.ToString("yyyy-MM-dd") '2001-03-06

Contributors

Topic Id: 3727

Example Ids: 12882,12883

This site is not affiliated with any of the contributors.