Best method for two digit month

Discussion created by techt on Jan 30, 2012
Latest reply on Jan 31, 2012 by techt

I've done some digging, and other than use what I've been using, I'm wondering if anyone has a better way to pad a single digit month to two digits. The same hold true for dates as well. What I've been using is to have the calculation occur on the fly as short date value is needed. Below is the month, which would be in a longer string to include year, date, as well as any other formatting the client may require.


Right ( "0" & Month ( Get ( CurrentDate ) ) ; 2 )


It's quick, easy, and works, but I'm wondering if there isn't something I'm missing ( FMI has made tons of changes over the past 20 years ) that would make this easier.