Is their any function that converts month name to number for example when I pass 'Jan' it should return number 1
how convert text (January) to month (1)
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:
to point to Apr:
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.
I changed firstmonthofyear to 4 but still not able to get 1 corresponding to Apr using the above expression.
Can you tell me vice versa as well i.e. fetching month name from month number
Retrieving data ...