Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
It will Return 2 digits of Year
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 🙂