Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

1 Solution

Accepted Solutions
Not applicable
Author

Date(Start_Date, 'MM')

View solution in original post

2 Replies
Not applicable
Author

Date(Start_Date, 'MM')

Not applicable
Author

It worked perfectly. Thanks!