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 vote187 views1 answer
Convert number to minutes in vba
VBA
3 votes171 views1 answer
Excel vba read registry key value
VBA
5 votes211 views1 answer
Vba low word from Long Integer
VBA
2 votes198 views2 answers
Excel vba if sunday or staurday
VBA
0 vote194 views1 answer
Vba min
VBA
0 vote185 views1 answer
Loop through all text boxes in a form vb
VBA
0 vote172 views1 answer
Excel vba disable copy paste
VBA
0 vote192 views1 answer
Vba code for cutoff time
VBA
1 vote187 views1 answer
Vbs run
VBA
0 vote178 views1 answer
Vba collection contains
VBA