4 Replies Latest reply: Jul 18, 2011 4:36 PM by MiguelMena RSS

    Why it is adding a day to the date data when exported into excel in QV V10 R2

      Hi,

       

      Has any one encounter this issue and is there something it can be done to prevente it?

       

      When data is exported to Excel, the date is changed - it becomes a day later.  For Example, the data below in QlikView V10 R2 shows dates of 7/3/2011 and 7/10/2011 and when exported to excel it shows 7/4/2011 and 7/11/2011 respectively

       

      Transfer to Excel the date changes to a day later...

      THD Year

      THD Month

      Week End Date

      Item name

      Item number

      2011

      Jul 2011

      7/4/2011

      8x205x1210 THD Cherry ST54 AC3

      367211-00099

      2011

      Jul 2011

      7/11/2011

      8x205x1210 THD Cherry ST54 AC3

      367211-00099

      2011

      Jul 2011

      Total

       

       

      2011

      Total

       

       

       

       

      Thanks for your help.

       

      Miguel Mena

       

      This is an Scramble sample: