Here, you are trying to convert a string to number. Qlikview doesn't understand it unless you tell him that it's a date:
Thanks for your replies although i cannot seem to get any of them to work correctly.
I have attached a sample, could someone show me the correct way on the sample please?
So i want the current date format 'JUL-2013' to show the number format (month start)