Exporting date to excel

Wed, 06 Jan 2010 10:07:11 GMT

Hello,

I have a table with a date value, some dates are before 1900, when exporting to excel those dates are not correctly exporting, I get some negativ numbers in excel. I have seen that excel manages date from 01/01/1900, so what are we suppose to do to get correct values ?

Thanks,

Exporting date to excel

Anonymous — Wed, 06 Jan 2010 10:22:54 GMT

Hi,

I think there are some plugins available to give Excel additional date format features but it's probably not possible to get these to play along with "Send to Excel".

What I can think of is to format the dates as Text for export. I put together a small example where if you export TextDate to excel it shows the dates. To get the order correctly I sort the TextDate listbox on the expression: Date

Let vStart = -50;
Let vEnd = 100;
Load
 Date($(vStart)+IterNo()) as Date,
 text(Date($(vStart)+IterNo())) as DateText
autogenerate 1
while $(vStart)+IterNo()<$(vEnd);

topic Exporting date to excel in QlikView

Exporting date to excel

Exporting date to excel