Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vinod2086
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
shraddha_g
Partner - Master III
Partner - Master III

It will Return 2 digits of Year

daniel_kusiak
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 🙂