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 vote320 views1 answer
Send webhook vbscript
VBA
1 vote304 views1 answer
Add a index column power bi
VBA
1 vote327 views1 answer
Excel vba to lower case
VBA
1 vote308 views1 answer
S yyyy-MM-dd HH:mm:ss Short Date Local
VBA
1 vote295 views1 answer
How to do error handling in access vba
VBA
0 vote309 views1 answer
Excel vba saveas no prompt for overwrite
VBA
1 vote322 views1 answer
Export datagridview to excel vb.net
VBA
0 vote278 views1 answer
Vba select file in folder
VBA
0 vote353 views1 answer
Vbs run with cscript
VBA
0 vote331 views1 answer
Vba is integer
VBA