S scott Jun 17, 2006 #1 Is there an easy way to "pad" the Month() and DAY() Functions? So if MONTH(dATE()) EQUALS 6, I need 06 as a result.
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 Jun 17, 2006 #3 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.
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.
