This content has been marked as final. Show 2 replies
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.