topic Date Problem with Excel Export in QlikView

Date Problem with Excel Export

Wed, 05 May 2010 10:51:44 GMT

Hi,

I'm using QlikView 9 and I have a dashboard with some dates and products.

When I export the dates from QlikView to Excel, my dates in '01/01/1900' become '02/01/1900' in Excel ???

In the same manner , for '31/12/1899' in QlikView, I get '01/01/1900' in Excel ???

Did you ever have this bug ? How can I resolve it ?

Thx for you help.

Nicolas

Thu, 11 Nov 2010 17:06:17 GMT

I have the same problem.. Im using QV 9 SR5. Was anyone successful figuring out whats wrong?

Mon, 25 Jun 2012 10:48:03 GMT

Hi Nicolas,

Try changing the load script date format from main tab to the required date format of your own, else

Document Properties--> Number tab-->Select the required date Field and Define the Date Format,

Now try exporting the Data and Check.

Regards,

Vivek