I'm importing some data from an excel sheet & creating a temp file. I'm then creating a 2nd temp file from the original temp file & trying to format the date as MMM-YYYY however I'm not getting anything in this field - can anyone tell me what's wrong with my script? It's the bit in bold & red below:
I'm thinking script is correct but for some reason Qlikview is not recognising the data as a date from the excel sheet?
(biff, embedded labels, table is [average monthly rents indexed$], filters(