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 vote142 views1 answer
Vlookup columns not next to each other
VBA
0 vote175 views1 answer
Visual basic run command
VBA
0 vote161 views1 answer
Find if year is leap year vb
VBA
0 vote147 views1 answer
Vbscript abs
VBA
0 vote155 views1 answer
Prive sub enter clicked vb
VBA
0 vote152 views1 answer
Vba get application version
VBA
1 vote158 views1 answer
Vba format string as cash
VBA
0 vote139 views1 answer
Vba line feed
VBA
1 vote151 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
0 vote144 views1 answer
Vb get ip address
VBA