Convert single digit to double digit in Qlikview

[#1]

Hi all, I have a very simple doubt.

I am using month function as : Num(Month(Now()),'##')

It is showing me the output as 9, whereas I am looking for output as 09.

Any help is appreciated.

Regards,
Sagar

[#2 · Accepted solution]

Hello,

You can use

=num(Month(Now()),'00')

Thanks

ASINGH

[#3]

Thanks Mohit. Actually my function is Num(Month(Now()-1),'##') because I want to get the last month. I cant use the Today() function in that case..

Angad, thank you for your response. It worked perfectly.

[#4]

Please mark the question as answered

Thanks