Which function can i use in vba similar to the one i used in sql

Question

i have tis code in sql and it works but which function can i use in vba to archive the same result.

RIGHT('00' + MONTH(lt.LveFromDate),2) --2021-03 --2021-03 --YEAR(lt.LveFromDate)

Answer 1

try,

Sub test()
  Dim s As String
  Dim myDate As Date
  
  myDate = Date
  s = Format(myDate, "yyyy-mm")
    
End Sub