Month(date) and Year(date)

[Collin79]

Hi!

I need the Month and Year of the date system, I'm using Month(date) and Year(date) function and it works ok, but in month I need two digits (february=02 not 2) and in year I need two digits too (01 not 2001)

I've tried with Format() but I can't do that, any hint?

Thanks

Collin79

 

[dsi]

Try this:

Dim sMonth As String
Dim sYear As String
    
sMonth = Format(Now, "mm")
sYear = Format(Now, "yy")
    
MsgBox "Month: " & sMonth & vbCrLf & _
       "Year: " & sYear

 

[pup]

Here's all you need. Format(Now,"MM YY&quot