excel - How can I format a certain string (date) in VBA?

Question

In order to fit my code, I needed to convert today's year to a two digit number (the last two digits). To test this, I tried:

Sub test()

Dim y As String

y = Format(Year(Now), "00")

MsgBox (y)
End Sub

I was told by a classmate that I could use the "Mid" function, but I'm not very familiar with VBA; any help?

question from:https://stackoverflow.com/questions/65864787/how-can-i-format-a-certain-string-date-in-vba

Answer 1

Try:

y = Format(Date, "YY")