Re: [Gretl-users] Exporting Date Variables from Excel to Gretl
- First Post
- Replies
- Stats
-
Go to
- ----- 2024 -----
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2008 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2007 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2006 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2005 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2004 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
Hi Gretl-users,
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?
Thank you all.
Attachments:
- attachment.html (text/html — 423 bytes)
Monday, 16 April
Mon, 16 Apr
12:33 p.m.
New subject: Exporting Date Variables from Excel to Gretl
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.
What version of gretl are you using, and what is the precise
(visible) format of the dates in the xlsx file? Current gretl
should recognize xlsx dates provided the format is a standard
one.
If you want to send me your xlsx file I'll take a look.
Allin Cottrell
Tuesday, 17 April
Tue, 17 Apr
11:40 p.m.
New subject: Exporting Date Variables from Excel to Gretl
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
4385
days inactive
4386
days old
2 comments
2 participants
tags (0)
participants (2)
-
Allin Cottrell -
Beatrice Benavidez