bill201
asked on
how can i get with vba the curret month with two digits
hi
i'm trying this code
MsgBox Format(Month(Now), "MM")
i want to get the month in two digits like this "06" but for some reason i get a msgbox with "01", why i don't get the right month?
i'm trying this code
MsgBox Format(Month(Now), "MM")
i want to get the month in two digits like this "06" but for some reason i get a msgbox with "01", why i don't get the right month?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks a lot
MsgBox Format(Now, "MM")