Month format

[Anonymous]

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?

[sasiparupudi1]

May be try

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

[sudhirpkuwar]

Hi

use this

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

[eduardo_dimperio]

TIMESTAMP([YOURMONTH],'MM')

[vamsee]

Hello,

Try this

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

Regards

Vamsee