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

2 votes221 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
0 vote209 views1 answer
Afficher un message d'erreur vba
VBA
1 vote221 views1 answer
Add a index column power bi
VBA
0 vote213 views1 answer
Do while not vb.net
VBA
1 vote207 views2 answers
Get all column names from excel vba
VBA
0 vote207 views1 answer
Vbnet line graph smooth lines
VBA
4 votes222 views2 answers
Vba create folder if not exist
VBA
0 vote216 views1 answer
Vba sheet visible
VBA
7 votes234 views1 answer
Excerl vba array to range
VBA
1 vote222 views1 answer
Vbscript convert ascii code to character
VBA