Month Format

[abhaysingh]

Dear All,

i have month in

1,2,3,4,5,6,7,8,9,10 format

i want it in 01,02,03,04,05,06,07,08,09,10 format

how i can do this?

[Anonymous · Accepted solution]

use num(month,'00')

[MK_QSL]

Date(Date#(Month,'M'),'MM') as Month

[hariprasadqv]

Linder is right, in a simple way.

[anbu1984]

=Right('0'&Month,2)

[#6]

Try this instead:

Dual(Month(MyDate) & '-' & Date(MyDate, 'YY'), Num(Year(MyDate)) & Num(Month(MyDate), '00')) AS Month Year, 

Note the Date(MyDate, 'YY') in the expression above.

[mukesh24]

Hi Abhay,

As suggested by Linder, simple way use num(month,00)

[#8]

Hi,

You can try this,

IF(LEN(MONTH_field)=1,month(month#(MONTH_field,'M'),'MM'),if(LEN(MONTH_field)=2,month(month#(MONTH_field,'MM'),'MM')))

[#9]

Hi try this expression also

Date((YourDateField,'MMM-YY') as YourDateField

[#10]

Hi,

You can try this in script,

IF(LEN(MONTH_field)=1,month(month#(MONTH_field,'M'),'MM'),if(LEN(MONTH_field)=2,month(month#(MONTH_field,'MM'),'MM')))   as   month