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

5 votes144 views1 answer
Excel vba second byte from INTEGER
VBA
0 vote126 views1 answer
Excel vba disable keyboard input
VBA
0 vote112 views1 answer
Style percent not found vba
VBA
0 vote81 views1 answer
Vba code to remove leading and trailing spaces
VBA
0 vote121 views1 answer
Excel vba formatconditions range
VBA
0 vote128 views1 answer
Refer to resource using string variable vb.net
VBA
0 vote132 views1 answer
Windows Presentation Foundation dark title bar
VBA
0 vote122 views1 answer
Vba declare 64-bit ptrsafe
VBA
0 vote115 views2 answers
Excel vba prevent save
VBA
0 vote120 views1 answer
Vbnet dynamically change excel sheet name
VBA