This content has been marked as final. Show 4 replies
I am loading some dates from an Excel, which are formatted as date in Excel and represented like "01.05.2017".
When I load my crosstable in QlikView the date field displays numbers, e.g. 42877 - that's fine till then, BUT they are recognized as a text, they are stated on the left side of the field in the frontend.
And formatting in the script with date(date#(Date_Field,'DD.MM.YYYY'),'DD.MM.YYYY') as Dates_New
does not help anything, these numbers are still shown on the leftside, instead of the right.
Can anybody help please?