Skip to main content
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Month column issue

Hi Team,

i have scenario, i have a month column present and it is displaying values like 1.2.3..etc but here instead of 1,2,3 i want to display 01,02,03..etc

Thanks in advance.

11 Replies
Partner - Master III
Partner - Master III

It will Return 2 digits of Year

Creator II
Creator II

In fact, it will return last two digits of Year. But with makedate we are making dates from month ex. 1,2,3 etc.

So the results are 01,02,03. Please take a look at the attached file.

Ofc num(MonthField,'00') is much better 🙂