4 Replies Latest reply: May 23, 2017 12:52 AM by mahesh kumar RSS

    Load dates from Excel

    Christian Schmitz



      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?