Page 1 of 1

Trouble exporting date formats to Excel

Posted: Wed May 13, 2015 1:29 pm
by jthodge
I'm trying to save a group in a workfile to an xlsx file using the pagesave command. Some of the members of the group are date series (this is an unstructured workfile). I set the display format of the date series to "mm/dd/yyyy", however when I save the group, the associated xlsx file shows them as "YYYY-MM-DD". Is Eviews doing the reformatting or Excel? Any suggestions you can offer will be appreciated.

Re: Trouble exporting date formats to Excel

Posted: Fri May 15, 2015 8:00 am
by EViews Jason
We are looking into the issue and will keep you posted

Re: Trouble exporting date formats to Excel

Posted: Fri May 15, 2015 10:38 am
by EViews Jason
EViews is writing the format. Unfortunately the format is hardcoded to YYYY-MM-DD and cannot be changed right now.

You will have to manually change the format within Excel by selecting the column and then applying the appropriate format.