Month column issue

[vinod2086]

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.

[shraddha_g]

It will Return 2 digits of Year

[daniel_kusiak]

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 🙂