On Mon, 16 Apr 2012, Beatrice Benavidez wrote:
I'm having trouble exporting date variables from Excel to Gretl.
For
example - in date form, 9 September 2011 is 09/10/11 but in general form,
it is 40491. When I export my xlsx file to Gretl, the date variable becomes
40491 in Gretl0.
How do I export the date variables from Excel to Gretl to look like
09/10/11 or its equivalent Gretl format as opposed to 40491?
Just for the record, it turned out the problems in ths case were:
1) The dates were not in the first column in the xlsx file, so gretl
didn't even try to treat them as such.
2) The dates were not in consistent chronological order: they went
in forward order for many rows, then backtracked. So even if you
asked gretl to start reading at the dates column, the dates didn't
make sense as representing time-series data.
Allin Cottrell