Reading dates

[michael.chon...@gmail.com]

I thought this data set on "Interest rate on securities" is pretty
cool: interest rates from 1976 to 2006 from 4 types of securities. But
the dates part is unusuable. It's in a YYYY-MM format. Here's the link
to the data.

http://www.swivel.com/data_sets/show/1002237

[dmi...@swivel.com]

Michael,

I'll add this format to the list. In the mean time, see if you can
change the format of the date in Excel. Here's a list of date/time
formats Swivel supports right now:

Mon May 08 19:16:30 PDT 2006
Mon May 08 19:16:30 2006
Mon May 08 2006
May 08, 2006
FY 2006
Aug-06
Aug-2006
Aug 06
Aug 2006
31-May
31-May-06
06
2006
'06
7/05, 12/06
20 Jun 2:00 pm
12/15/06 12:23:23
12-15-06 12:23:23
12-15-2006 12:23:23
20061206 12:23:23

Thanks,
Dmitry

On Feb 8, 11:28 am, "mich...@swivel.com"

[Micah Sittig]

Has that data format been added yet? Because just today I tried to
add a data set with dates in that format and it didn't work. Putting
the year first is part of lots of ISO standards, and is understood
across many countries. It would be nice if YYYY-MM-DD works as well.

--Micah

[dmi...@swivel.com]

Micah,

We're fixing it this week, I'll let you know when it's out. Thanks for
your patience.

Dmitry

[Dmitry Dimov]

This fix was deployed this past Monday. YYYY-MM-DD and YYYY-MM are both supported now.

Thanks,
Dmitry