4 Replies Latest reply: Feb 1, 2013 8:06 AM by Kabilan Kumarasamy RSS

    Correct date format in XML file

      I have some XML files that I am loading into Qlikview. Here's a fragment from a node:

       

      <Exclusion><StartDate>17/01/2003 00:00:00</StartDate><EndDate>24/01/2003 00:00:00</EndDate></Exclusion>
      

       

      I've loaded them in but it looks like Qlikview is treating the date as a number rather than a proper date / time value - how should I format the XML so that Qlikview loads it properly?