Will it possible to change ODK date format "yyyy-mm-dd 00:00:00.0" to "yyyy-mm-dd"

Hi all,

In ODK form i have a date field,

Like:
type name label

··· ----------------------- date BG_Date Date:

When i send the finalized data to Odk aggregate server.
On ODK Aggregate server date available in the format of "yyyy-mm-dd 00:00:00.0"
example :2013-08-28 00:00:00.0

which was given me problem on further coding because previously i had data in the format of "yyyy-mm-dd"
example :2013-08-28

Is it possible to change the ODK Aggregate generate date format to simple date format
i.e : 2013-08-28 00:00:00.0 to 2013-08-28

any help

Thanks

Kanhu

Kanhu,

You can't change the date format without writing code in Aggregate. If
you export the data to CSV or stream it to
FusionTables/Spreadsheets/JSON, you can probably do these
transformations on those platforms.

One alternative to try is to use the format-date-time() option in the
XForm so that on your device running ODK Collect, you convert the date
to a yyyy-mm-dd format. I haven't tried this myself, but should work.
See https://code.google.com/p/opendatakit/wiki/CollectReleaseNotes
(r1033) for a quick description of that feature.

Yaw

··· -- Need ODK services? http://nafundi.com provides form design, professional support, custom reporting, and software development for ODK.

On Wed, Sep 4, 2013 at 7:11 AM, kanhu.gs@gmail.com wrote:

Hi all,

In ODK form i have a date field,

Like:
type name label

date BG_Date Date:

When i send the finalized data to Odk aggregate server.
On ODK Aggregate server date available in the format of "yyyy-mm-dd 00:00:00.0"
example :2013-08-28 00:00:00.0

which was given me problem on further coding because previously i had data in the format of "yyyy-mm-dd"
example :2013-08-28

Is it possible to change the ODK Aggregate generate date format to simple date format
i.e : 2013-08-28 00:00:00.0 to 2013-08-28

any help

Thanks

Kanhu

--

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


You received this message because you are subscribed to the Google Groups "ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.