Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Communities,
I was trying to load an excel file to qlikview, there's one column contain the date information called YearMonth, the format like 201801.
Once the excel loaded in the qlikview, the date convert to numeric automatically, the it shows 43101.
I'm trying to convert it to date format by using Date() and Date#(), but the format wasn't converted well.
Please attached example is for your reference.
Thanks a lot
Kate
Hi kate,
Try this:
= DATE#((Today()),'MM/D/YYYY')
Thanks
If you are getting number in qlik while loading, you could use only date() to format it like:
Load
Date(NumberFromExcel, 'YYYYMM') as Date // use your desired date format in date()