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 vote169 views1 answer
Excel vba autofit
VBA
0 vote161 views1 answer
Excel vba assign shortcut key to button
VBA
0 vote161 views1 answer
Excel vba existence of a file
VBA
0 vote164 views1 answer
Excel vba calculate
VBA
0 vote118 views10 answers
Vba excel create event log
VBA
31 votes284 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
0 vote161 views1 answer
Vba parameter adodb null value
VBA
0 vote170 views1 answer
Vba dictionary clear
VBA
18 votes308 views3 answers
Excel-vba make integer
VBA
1 vote170 views1 answer
Add rows to datagridview vb.net
VBA