Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is their any function that converts month name to number for example when I pass 'Jan' it should return number 1
Use this
=If(num(month(date#(MyMonthName,'MMM')))<4,num(month(date#(MyMonthName,'MMM')))+9,
num(month(date#(MyMonthName,'MMM')))-3)
Regards
pratyush
=num(month(date#(MyMonthName,'MMM')))
how convert text (January) to month (1)
Hi Michele,
Thanks for your answere its working , can you suggest me something if I want April month to have 1 number.
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.
Hi ,
I changed firstmonthofyear to 4 but still not able to get 1 corresponding to Apr using the above expression.
Use this
=If(num(month(date#(MyMonthName,'MMM')))<4,num(month(date#(MyMonthName,'MMM')))+9,
num(month(date#(MyMonthName,'MMM')))-3)
Regards
pratyush
Can you tell me vice versa as well i.e. fetching month name from month number