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 vote218 views1 answer
Excel vba prevent saving workbook
VBA
0 vote199 views1 answer
Vba first cell in range
VBA
2 votes202 views1 answer
Vba split string
VBA
0 vote219 views1 answer
Set column width of datagridview vb.net
VBA
0 vote210 views1 answer
Enable macros on opening workbook vba
VBA
0 vote216 views1 answer
Ribbon show/hide
VBA
15 votes500 views2 answers
Xl vba dynamic string array
VBA
0 vote228 views1 answer
Selecttoken em vbnet e json
VBA
0 vote218 views1 answer
Vba format currency
VBA
0 vote241 views1 answer
How to enter Vbox manage commands
VBA