HELP: Aggregate v1.2 changed time format when publishing data to google spreadsheet

Recently found that datetime format changed when publishing data from
Aggregate to google spreadsheet:
were: 3/3/2012 22:02:09
became: 09/30/2012 13:06:37*.193*
so google spreadsheet doesn't recognize this value as a datetime format

Help with any suggestions how to convert it in google spreadsheet or in
aggregate?

Found how to convert it in spreadsheets.
What about Aggregate 1.2?

Aggregate 1.2 has special formatting for google dates, see the code at.
http://code.google.com/p/opendatakit/source/browse/src/main/java/org/opendatakit/aggregate/format/element/BasicElementFormatter.java?repo=aggregate

If you are seeing an issue and verify your version is Aggregate 1.2 please
file an issue on our website and we will take a look at what has changed.

http://code.google.com/p/opendatakit/issues/list

Regards,
Waylon

ยทยทยท On Sun, Sep 30, 2012 at 9:55 AM, vlcity polls wrote:

Found how to convert it in spreadsheets.
What about Aggregate 1.2?

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en