Vba string to date

Dim myDate As Date, strDate As String
myDate = CDate("2021-01-28")
strDate = Format(myDate, "YYYY-MM-DD")				  ' 2021-01-28
' String to date
myDate = CDate(Format$("20210213101235", "####-##-## ##:##:##"))
' Date to string
strDate = Format(myDate, "YYYY-MM-DD hh:mm:ss")       ' 2021-02-13 10:12:35

String to date vb

Dim iDate As String = "05/05/2005"
Dim oDate As DateTime = Convert.ToDateTime(iDate)
MsgBox(oDate.Day & " " & oDate.Month & "  " & oDate.Year)

Source: net-informations.com

Similar codes

18 votes570 views2 answers
Vba make word from bytes
VBA
0 vote384 views1 answer
Vbnet cycle through charaters in string
VBA
1 vote308 views1 answer
Vba Remove Case Sensitivity
VBA
15 votes510 views1 answer
Excel vba wait
VBA
0 vote399 views1 answer
Excel vba set cell value to empty
VBA
0 vote414 views1 answer
Vba find last column in a row with data
VBA
0 vote346 views1 answer
Refresh token em vb net
VBA
32 votes561 views2 answers
Excel vba column letter
VBA
3 votes348 views1 answer
Vba folderexists
VBA
0 vote363 views1 answer
Vba timestamp -- milliseconds
VBA