David,
If you're converting directly from an Excel file (instead of pasting in
tab separated values), then cells with dates should have been read as
dates... but then I can't speak for the java library I used to read
Excel files. I myself had trouble getting Excel itself to recognize any
date I typed...
But you can just try to enter the dates as text in ISO 8601 format, e.g.,
2006-12-22
2006-12-22T12:17:00Z
More at http://en.wikipedia.org/wiki/ISO_8601 .
Also, in the column header, append ": date" to the property name, e.g.,
birth-day : date
That will make Babel generate a schema in which the value type of the
"birth-day" property is "date".
Let me know if that works.
David
[EMAIL PROTECTED] wrote:
> Despit numerous attempts, I cannot set the time format in an
> Excel spreadsheet so that when I convert using Babel the
> correct time format is retained and is correct. I am
> converting from an Excel spreadsheet to Exhibit JSON. Can
> someone please offer some guidance? Thank you for your
> assistance.
>
> --
> David L. Cohen
>
> _________________________________________
>
> Check your Email accounts at MyEmail.com
>
> Login from home, work, school. Anywhere!
>
>
> _______________________________________________
> General mailing list
> [email protected]
> http://simile.mit.edu/mailman/listinfo/general
>
_______________________________________________
General mailing list
[email protected]
http://simile.mit.edu/mailman/listinfo/general
