Page 1 of 1

Dates in a series saved as a day and not fixed character

Posted: Thu Aug 06, 2015 6:17 am
by CharlieEVIEWS
Dear all,

I have been collating a large number of individual csvs through unstructed workfiles, transferring dates from one series into another. I have a final 'master' file. However, when I attempt to write the master file to a csv, txt, .dat, xls, xlsx, the dates are being converted into the scalar represenations( fixed characters?) that eviews has them stored under (.e.g 733996) instead of the day representation which you see in the workfile. Is there any way\trick to save them out as dates (e.g. 2013-04-09 etc) as opposed to fixed characters? cant figure it out.

Best wishes, help appreciated!

Charlie

Re: Dates in a series saved as a day and not fixed character

Posted: Thu Aug 06, 2015 7:46 am
by EViews Gareth
It shouldn't do that, but you can always create a datestring series.

Code: Select all

alpha mydates = @datestr(@date, "YYYY-MM-DD")

Re: Dates in a series saved as a day and not fixed character

Posted: Thu Aug 06, 2015 8:44 am
by CharlieEVIEWS
Argh, that must be the only function i didnt try. Thanks Gareth. I think the way dates in series are being written to disk in general is a little bit inconsistent. After extensive testing, EV9 would seldom save it as a date representation, but at other times as a fixed character, although I couldnt discern what was causing the variation.

Thanks for your help,

Charlie