Trouble exporting date formats to Excel

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Moderator, EViews Jason, EViews Matt

jthodge
Posts: 77
Joined: Tue Oct 21, 2008 5:52 am

Trouble exporting date formats to Excel

Postby jthodge » Wed May 13, 2015 1:29 pm

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.

EViews Jason
EViews Developer
Posts: 870
Joined: Tue Sep 16, 2008 3:50 pm

Re: Trouble exporting date formats to Excel

Postby EViews Jason » Fri May 15, 2015 8:00 am

We are looking into the issue and will keep you posted

EViews Jason
EViews Developer
Posts: 870
Joined: Tue Sep 16, 2008 3:50 pm

Re: Trouble exporting date formats to Excel

Postby EViews Jason » Fri May 15, 2015 10:38 am

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.


Return to “Programming”

Who is online

Users browsing this forum: No registered users and 2 guests