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

3 votes380 views2 answers
Vba date to string
VBA
4 votes328 views1 answer
Excel formula for last non-empty cell in a column
VBA
0 vote358 views1 answer
Excel vba StartUpPosition
VBA
0 vote334 views1 answer
Excel vba disable alerts
VBA
1 vote354 views1 answer
VBA Loop through recordset
VBA
3 votes361 views1 answer
Extract the nth word from a text string
VBA
0 vote357 views1 answer
Excel vba round to whole number
VBA
22 votes743 views1 answer
Excelvba check for directory
VBA
-1 vote384 views1 answer
How save excel through visual basic
VBA
0 vote361 views1 answer
Menus act like radio buttons vb.net
VBA