This content has been marked as final. Show 7 replies
I have an issue while converting a date from 'yyyymmdd' to 'DD/MM/YYYY'.
I am using the below formula in my Load script:
Date(alt(Date#(DATE, 'yyyymmdd')), 'DD/MM/YYYY') as Date
It gives me the correct answer in my table on qlikview.
However when I export the table in excel it becomes like this:
Also, when i try using the expression =if(Date= today(), Date) to get the data of only today, my table becomes empty.
Any idea why?