Format month as MM instead of M

[#1]

Hello All,

I have figured out how to get the month out of my date field by writing month(Start_Date) which gives me January (for example). I also know that if I put num(month(Start_Date)) I will get "1" as my answer for January. My question is: how can I get months before October to be  written with numbers and a 0 if it is a single digit (i.e. "01" as opposed to 1) while not creating problems with October, November, and December ("10", "11", "12") ?

Any suggestions would be most appreciated.

Thanks,

S.H.

[#2 · Accepted solution]

Date(Start_Date, 'MM')

[#3]

It worked perfectly. Thanks!