Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Month format

Hi experts,

I am having Month filed having the data

1,2,3,4,5,6,7,8,9,10,11,12

but i want the output like

01,02,03,04,05,06,07,08,09,10,11

can you please help me on the same?

4 Replies
sasiparupudi1
Master III
Master III

May be try

Date(MakeDate(2018.yourMonth),'MM')

sudhirpkuwar
Partner - Creator II
Partner - Creator II

Hi

use this

=if(len(Month<=1),'0' & Month,Month)

eduardo_dimperio
Specialist II
Specialist II

TIMESTAMP([YOURMONTH],'MM')

vamsee
Specialist
Specialist

Hello,

Try this

     Date(Date#(Month_Field, 'M') ,'MM')

Regards

Vamsee