topic Load Date from Excel in QlikView

Load Date from Excel

Athira_K — Thu, 09 Dec 2021 09:38:25 GMT

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?

Re: Load Date from Excel

anat — Thu, 09 Dec 2021 09:52:09 GMT

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

Re: Load Date from Excel

Or — Thu, 09 Dec 2021 09:54:09 GMT

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