Format month as MM instead of M

Wed, 20 Mar 2013 14:21:17 GMT

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.

Re: Format month as MM instead of M

Wed, 20 Mar 2013 14:39:41 GMT

Date(Start_Date, 'MM')

Re: Format month as MM instead of M

Wed, 20 Mar 2013 14:41:53 GMT

It worked perfectly. Thanks!

topic Re: Format month as MM instead of M in QlikView

Format month as MM instead of M

Re: Format month as MM instead of M

Re: Format month as MM instead of M