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

    Date pulled from excel is neglecting Year

    DIVYA ANAND

      Hi,

       

      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.