Transform date represented as String to Date in Visual Basic

Question

I am using SSIS and I need to transform a date. How can I transform a date in String format (e.g. 14/09/1980) to the same but in date format in VB.NET?

I would like the datetime format to insert it into a SQL database.

Answer 1

In VB.NET:

' Assume the current culture is en-US. 
' The date is Feburary 16, 1992, 12 hours, 15 minutes and 12 seconds.
Dim myDateTimeValue As String = "2/16/1992 12:15:12"  
Dim myDateTime As DateTime = DateTime.Parse(myDateTimeValue)

' Reverse month and day to conform to a different culture.
' The date is Feburary 16, 1992, 12 hours, 15 minutes and 12 seconds.
Dim cultureGB = New CultureInfo("en-GB", True)
Dim myDateTimeValue As String = "16/2/1992 12:15:12"  
Dim myDateTime As DateTime = DateTime.Parse(myDateTimeValue, cultureGB)

' Dsiplay the date in DD/MM/YYYY format
Debug.Print Format(myDateTime ,"dd/MM/yyyy")

Reference: http://msdn.microsoft.com/en-us/library/1k1skd40%28VS.80%29.aspx

In VB6:

dim dt as date
dim s as string
s="10/09/2009"
dt = cdate(s)