Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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.

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Format month as MM instead of M

Date(Start_Date, 'MM')

2 Replies
Not applicable

Re: Format month as MM instead of M

Date(Start_Date, 'MM')

Not applicable

Re: Format month as MM instead of M

It worked perfectly. Thanks!