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

    Load dates from Excel

    Christian Schmitz

      Hi,

       

      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?

       

      Chris