export date before 1900

For notifying us of what you believe are bugs or errors in EViews.
Please ensure your copy of EViews is up-to-date before posting.

Moderators: EViews Gareth, EViews Moderator

startz
Non-normality and collinearity are NOT problems!
Posts: 3775
Joined: Wed Sep 17, 2008 2:25 pm

export date before 1900

Postby startz » Wed Jan 17, 2018 3:22 pm

Odd bug. Do export to file on a series and select .xlsx Dates before 1900 are exported as #N/A

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13305
Joined: Tue Sep 16, 2008 5:38 pm

Re: export date before 1900

Postby EViews Gareth » Wed Jan 17, 2018 4:07 pm

Because Excel doesn't do dates before 1900 properly. https://support.microsoft.com/EN-US/help/214058
Follow us on Twitter @IHSEViews

startz
Non-normality and collinearity are NOT problems!
Posts: 3775
Joined: Wed Sep 17, 2008 2:25 pm

Re: export date before 1900

Postby startz » Wed Jan 17, 2018 4:20 pm

You could write out earlier dates as text, although I guess I can see where that could lead to confusion.


Return to “Bug Reports”

Who is online

Users browsing this forum: No registered users and 3 guests