pad single digit number with leading zero 2

[kiwuji]

I have a query that retrieve month from database but i want the single digit number to be pad with a leading zero.
this the query
select Month(date()) as [MONTH]
from TABLENAME

currently returns
1 to 9

i want it to return
01 to 09

Thanks,
kiwuji

 

[drtree]

Try this:

iif(Month(date()) < 10, 0 & Month(date()), Month(date())

That is an immediate if statement, and it is checking to see if the month function returns a number less than 10. If it does, it prepends a zero (0) to the month, if not it simply returns the month value. HTH!

 

[kiwuji]

Thank you so much drtree,
it's working nice

kiwuji

 

[mikevh]

How about

Format(Month(date()),&quot;00&quot

Then you don't need to bother with the iif.

 

[johnnygeo]

As a generalized solution, where you need to add leading zeroes to MyString to bring it up to MyLength, you can use this:

=String(MyLength-len(MyString),&quot;0&quot&MyString