Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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);