I hve attached the excel file and i have to convert it in to date formate in qlikview,i have used date and date# functions and timestamp and timestamp# functions. if i changed the format in the excel it is working, now i need to take out the time with out changeing the format in the excel.
Thanks and Regards,
Solved! Go to Solution.
Well within the Excel, the date is read as date... if this is true for your actual source... all you need is to do this
Date(Floor([Last Date / Time])) as Date
Date([Last Date / Time]) as Date;
LOAD [Last Date / Time]
(ooxml, embedded labels, table is Sheet1);