Dates in a series saved as a day and not fixed character
Posted: Thu Aug 06, 2015 6:17 am
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
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