Date format in Aggregate

Support
1

Dear all, when enumerators enter a date with the date field type, I get various entrances on aggregate:

a) 2018-07-10T00:00:00.000+02
b) 2018-07-10

I supose it has to do with the settings of the tablet. Is there a way I can enforce al date entrances to the b) format (2018-07-10), independent of the tablet settings? Thanks!

2

To get what you're asking, I think you could have a second question of type calculate and use the format-date(date,format) function.

+===========+=============+=======+====================================+
|   type    |    name     | label |            calculation             |
+===========+=============+=======+====================================+
| date      | my_date     | Date: |                                    |
+-----------+-------------+-------+------------------------------------+
| calculate | format_date |       | format-date(${my_date},'%d-%m-%y') |
+-----------+-------------+-------+------------------------------------+

And this feature will hopefully help when it is released:

1 Like