1 Reply Latest reply: Apr 14, 2013 1:38 AM by Ricardo Reaño RSS

    Dates From SAP BW

      I get data into Excel from SAP BW and I have a problem with the dates in Qlikview. Date is output as MM.YYYY e.g 10.2012 or 4.2013. When i load my files into Qlikview it doesn't recognise these as dates and sorts them incorrectly like this

       

      1.2012

      1.2013

      2.2012

      2.2013

      etc etc

       

      I have looked at various posts without success. If someone could explain exactly what code I need and exactly where I should put it in the script. Do I also have to do anything in my listbox etc I would be extremely grateful

       

      Thanks

       

      Derek

        • Re: Dates From SAP BW

          Hi Melvild1,

           

          The dates are text and certainly qlikview doesn't recognize as date. In your script, you should include the date#() function (converts text to date) on your field, for example:

           

          LOAD

               ...

               Date(Date#(FieldDateAsText, 'M.YYYY')) as FieldDate

               ...

          FROM ...

           

          Where FieldDateAsText, is the field that contents date as text.

           

          Regards,

          Ricardo