Date format conversion

Hi all,

Is there a way to convert the date format from yyyy/mm/dd to dd/mm/yyyy on
excel?

Thanks

··· On Wed, Apr 5, 2017 at 10:44 PM, wrote: > Hi all, > > Is there a way to convert the date format from yyyy/mm/dd to dd/mm/yyyy on > excel? > > Thanks > > -- > -- > 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/d/optout.

Hi, does this applies to ODK? Or just changing for excel? Because I want my
date format to be dd/mm/yyyy on ODK.

Hi there,

Since you didn't specify which tool you are using, I'll just touch on
popular tools.

If you want to change the date collection widget format in Collect,
that's set by the device locale. We are working on a feature to make
this configurable at the device (and perhaps form level) because we
have some strong evidence that some date formats have very high error
rates. You can track this feature at
https://github.com/opendatakit/collect/issues/424

If you want to change the date display when outputting date to the
user in Collect, then the format-date function at
https://opendatakit.org/help/form-design/binding/. See
https://groups.google.com/d/msg/opendatakit/b6wClWxScxw/i54z9ym_DQAJ
for a recent example.

If you want to change the date display in Aggregate, there's no easy
way to do that now. If this is an important feature for you, file a
feature request at github.com/opendatakit/opendatakit/issues/new
explaining why.

Thanks,

Yaw

··· On Fri, Apr 7, 2017 at 1:09 AM, wrote: > Hi, does this applies to ODK? Or just changing for excel? Because I want my > date format to be dd/mm/yyyy on ODK. > > -- > -- > 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/d/optout.

Thanks for the help!