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 vote294 views1 answer
Vb.net round to 2 decimal places
VBA
0 vote313 views1 answer
Internet explorer reference vba
VBA
0 vote325 views4 answers
How to continue formula in below line in vba code
VBA
1 vote315 views1 answer
Add a index column power bi
VBA
3 votes345 views1 answer
Excel vba make long from two shorts
VBA
0 vote312 views1 answer
Change whcih control a user has selected vb
VBA
0 vote328 views1 answer
Vbnet find highest value in chart
VBA
0 vote319 views1 answer
Switch pictures with buttons vb.net
VBA
0 vote336 views1 answer
Add text to Shape VBA
VBA
0 vote332 views1 answer
VBA OR vb6 find OR replace string from the end
VBA