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

4 votes130 views1 answer
Excel vba check cell not empty
VBA
2 votes141 views1 answer
Excel vba date to string conversion
VBA
1 vote127 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
0 vote134 views1 answer
Vb window.minimize
VBA
0 vote144 views1 answer
Vba range clear formatting
VBA
0 vote153 views1 answer
Vba count all row
VBA
0 vote137 views1 answer
How to use if condition in time vba
VBA
20 votes292 views1 answer
Excel vba factorial
VBA
25 votes269 views3 answers
String to date vb
VBA
0 vote145 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA