Pad Month() and DAY() Functions

S

scott

Is there an easy way to "pad" the Month() and DAY() Functions? So if
MONTH(dATE()) EQUALS 6, I need 06 as a result.
 
F

fredg

Is there an easy way to "pad" the Month() and DAY() Functions? So if
MONTH(dATE()) EQUALS 6, I need 06 as a result.
Click to expand...

Then why use Month(Date())?
=Format(Date(),"mm")
will return 06 for June.

Format(Date(),"dd")
will return 06 for the 6th of the month.
 
Top