Month column issue

[vinod2086]

Hi Team,

i have scenario, i have a month column present and it is displaying values like 1.2.3..etc but here instead of 1,2,3 i want to display 01,02,03..etc

Thanks in advance.

[arvind_patil]

Hi Kumar,

Try below one:

Date(Month(MonthField),'MM') As MonthField

Thanks,

Arvind Patil

[mdmukramali]

Dear,

Try 

Num(month,'##') as month

Thanks,

Mukram

[shraddha_g · Accepted solution]

Try num(MonthField,'00')

[vinod2086]

Hi,

thanks for your reply,

still expected values are not coming.

[mdmukramali]

Hi Kumar,

post sample data Apps.

[shraddha_g]

What are the values it giving?

[vinod2086]

now values are displaying 01,02 ..etc thanks, Sharaddha

[shraddha_g]

Great!

[daniel_kusiak]

Hi, try date(makedate(date_field),'YY') as date_field