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 votes347 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
1 vote331 views1 answer
How to check is the value enterd is a number or text in vba
VBA
0 vote368 views1 answer
Method showalldata of object _worksheet failed vba
VBA
0 vote347 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
0 vote359 views1 answer
Set datetimepicker value to null vb
VBA
5 votes372 views1 answer
Excel vba get user selected range
VBA
7 votes370 views1 answer
Excerl vba array to range
VBA
0 vote325 views1 answer
Vbs write file
VBA
0 vote380 views1 answer
Vbs run with cscript
VBA
0 vote348 views1 answer
Date as number vb
VBA