QV is generally very good at interpreting the dates, because it stores the dates in to integers/decimal points. If QV don't understand the date format then it converts them to string. So have you tried using the DATE Function in the Load script or you can clean up the dates in excel before loading the script.
Check out your date format it would be mm/dd/yyyy. since in first case the date is 3/4/2001 which is the valid date hence qlikview converts the date in the decimal format. but in the second case the date is 13/4/2011 in this as month is 13th which is not valid hence the qlikview taking it as a string..
i have tried the date function. But it works in Quite opposite way except the first column what it was showing in number is getting intrepted correctly in Qlikview and rest of the dates are not read in to Qlikview.
It is not working , I want to know whether this is issue with excel or QlikView. What should be format in Excel for the date column is there any restrictions.
.png "Miguel_Angel_Baeyens"){kind=avatar}
.png "Luminary Alumni"){kind=icon}
