export date before 1900
Posted: Wed Jan 17, 2018 3:22 pm
by startz
Odd bug. Do export to file on a series and select .xlsx Dates before 1900 are exported as #N/A
Re: export date before 1900
Posted: Wed Jan 17, 2018 4:07 pm
by EViews Gareth
Because Excel doesn't do dates before 1900 properly.
https://support.microsoft.com/EN-US/help/214058
Re: export date before 1900
Posted: Wed Jan 17, 2018 4:20 pm
by startz
You could write out earlier dates as text, although I guess I can see where that could lead to confusion.