2 Replies Latest reply: Mar 20, 2013 10:41 AM by Shannon Hapeman RSS

    Format month as MM instead of M

      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.