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 vote136 views1 answer
Vba variable number of arguments
VBA
0 vote135 views1 answer
WGET FTP
VBA
0 vote143 views1 answer
How to get value from clipboard in vbnet
VBA
5 votes76 views1 answer
Vlookup vba
VBA
20 votes260 views1 answer
Excel vba recursive example factorial function
VBA
0 vote131 views1 answer
How to get the value of optionbutton in vba
VBA
2 votes122 views1 answer
Vba uppercase first letter of each word
VBA
0 vote125 views1 answer
Vba like with wildcard
VBA
0 vote130 views1 answer
Vba get relative cell address
VBA
4 votes82 views2 answers
Vba last row
VBA