Hello I have a Mydate column in excel sheet in the format 14-Mar-2012 which is in 'date'. I have loaded the Mydate in qlikview using : Date([Mydate],'MMM-YY') as my_date. Now when i execute and put them in listbox, my_date is empty and when i put Mydate in listbox, it is displaying in the same format in excel (14-Mar-2012) in listbox. How can we implement it?
Check that the Excel file actually contains a date rather than a string (if it's a date, you can change the format to a number and you'll get something like 44542). It's probably just a string formatted like a date, but not actually a date type. If that's the case, you can try to force it to be read as a date by using date#(MyDate).
