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

0 vote244 views1 answer
Excel vba open browser
VBA
1 vote249 views1 answer
Excel vba hide zero values
VBA
2 votes282 views1 answer
Excel vba check if string entirely alpha
VBA
0 vote264 views1 answer
Vbnet get file name from path
VBA
0 vote266 views1 answer
Excel vba center userform
VBA
0 vote278 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA
0 vote306 views1 answer
Excel vba first column in range
VBA
0 vote285 views1 answer
Vba string
VBA
0 vote278 views1 answer
Vba simple quote
VBA
0 vote258 views1 answer
Putting marquee in vb.net
VBA