Load Date from Excel

[Athira_K]

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?

[anat · Accepted solution]

date(date#(Mydate,'DD-MMM-YYYY'))

[Or]

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).