Need to Insert Leading Zero to Month Value 1

[JohnBates]

hi experts,

If I use the month function, it returns a single digit (for months 1 thru 9).

I need to get it to a 2 digit value.
If I have : curMonth = month() I get a value of 1

How can I insert a leading zero to get a value of '01' ?

Pretty simple stuff, but I'm stumped.
Thanks, John

 

[tsuji]

Like this.
[tt]
curMonth=right("00" & month(now),2)
[/tt]
- tsuji

 

[JohnBates]

thanks tsuji.

That did it.
John