Date format in Aggregate

[danbjoseph]

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:

Standardize on ISO8601 for date and time exports in Briefcase, Aggregate, Central

What is the general goal of the feature? As a data manager, I would like to process dates and times that use standard formats. What are some example use cases for this feature? As described at Date format on export different on different machines (with identical setups), depending on the locale and version of Java you have, Briefcase will output date times in a different format. This makes it hard to write and manage downstream tools that work with the data. What can you contribute to making…