24 Replies Latest reply: Oct 12, 2017 11:09 PM by Anil Samineni RSS

    Date pulled from excel is neglecting Year

    divya anand



      The source file that I am trying to load has a date field as shown below:

      It clearly is displaying the date in a different format. when I pull this field into QlikView, for some reason it is not considering the year. I tried different combinations of Date & Date# but in vein.

      How can I pull the date field in DD/MM/YYYY format without making any changes to the excel sheet?


      Thank you.