month(Date)

[hkg_qlik]

Hi,

I would like to extract month info from a date (01/01/2014). Instead of getting Jan as the month output I would like to see 01 as the output.

Regards,

H

[phaneendra_kunc · Accepted solution]

Use this...

=num(Month('01/01/2014'),'00')