Solved: format of month - Qlik Community

P_qlik · ‎2021-04-27

Hi,

I have this formula: Num(Month(Date(today(), 'MM'))): the result is 4

how can I have format 04 for month?

Thank you

MayilVahanan · ‎2021-04-27

Try like below

Num(Month(Date(today())),'00')

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

MayilVahanan · ‎2021-04-27

Try like below

Num(Month(Date(today())),'00')

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

format of month