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

1 vote307 views1 answer
How to remove zeros in excel
VBA
0 vote289 views1 answer
Backspace key has stopped working visual studio
VBA
0 vote307 views1 answer
Excel vba protect sheet
VBA
0 vote311 views1 answer
Iterate all file in a folder vba
VBA
0 vote321 views2 answers
Excel vba number format file size
VBA
0 vote305 views1 answer
Vbs exec hidden
VBA
0 vote294 views1 answer
Priavte sub with multiple handels find sneder
VBA
1 vote278 views1 answer
Highlight selected cell in excel vba
VBA
0 vote277 views1 answer
Vbs send keys
VBA
0 vote287 views1 answer
Vba full date format
VBA