EXHIBIT. Dates in Google Spreadsheet don't work in Exhibit; GSS converts yyyy-mm-dd to mm/dd/yyyy

[GoogleCodeExporter]

I posted to
http://simile.mit.edu/wiki/Talk:Exhibit/How_to_make_an_exhibit_from_data_fed_dir
ectly_from_a_Google_Spreadsheet
but haven't had any replies so perhaps this is the place to post my issue:

Google Spreadsheets converts dates from yyyy-mm-dd format to mm/dd/yyyy. I
suspect this is why I'm having problems with dates not being seen as such.
Any recommendations? --Dmenyc 14:03, 15 August 2007 (EDT)

According to this page:
http://simile.mit.edu/wiki/Exhibit/Understanding_Exhibit_Database
Exhibit wants dates in "2006-12-08", see ISO 8601 format

unfortunately GSS does NOT like dates in that form.

I have entered my dates as 'yyyy-mm-dd using the ' to quote the data.

Looking @ "raw" data I don't see the leading '
   http://spreadsheets.google.com/pub?key=pGZ5wbN-VEUB432SPBEgsNA

...but the quote is clearly visible in on my Exhibit page:
http://www.panodex.com/PanoIndex/index.html

my Exhibit: http://www.panodex.com/PanoIndex/index.html
my data: http://spreadsheets.google.com/pub?key=pGZ5wbN-VEUB432SPBEgsNA

[Submitted by Daniel M Eldridge on simile.mit.edu] 

Original issue reported on code.google.com by GabrielR...@googlemail.com on 4 Apr 2009 at 4:18

[GoogleCodeExporter]

Original comment by GabrielR...@googlemail.com on 4 Apr 2009 at 6:55

• Changed title: EXHIBIT. Dates in Google Spreadsheet don't work in Exhibit; GSS converts yyyy-mm-dd to mm/dd/yyyy