Month name to number

[siddharthsoam]

Is their any function that converts month name to number for example when I pass 'Jan' it should return number 1

[micheledenardi]

=num(month(date#(MyMonthName,'MMM')))

how convert text (January) to month (1)

[siddharthsoam]

Hi Michele,

Thanks for your answere its working , can you suggest me something if I want April month to have 1 number.

[kuczynska]

You can always try to change variable FirstMonthOfYear from MAIN tab of your load script:

SET FirstMonthOfYear=1;

to point to Apr:

SET FirstMonthOfYear=4;

But you need to remember that this will make a global change for the entire app and your first month of the year will be April.

[siddharthsoam]

Hi ,

I changed firstmonthofyear to 4 but still not able to get 1 corresponding to Apr using the above expression.

[prat1507 · Accepted solution]

Use this

=If(num(month(date#(MyMonthName,'MMM')))<4,num(month(date#(MyMonthName,'MMM')))+9,

num(month(date#(MyMonthName,'MMM')))-3)

Regards
pratyush

[siddharthsoam]

Can you tell me vice versa as well i.e. fetching month name from month number