Date Problem with Excel Export

[#1]

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

[#2]

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

[#3]

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