Date format on Aggregate

Hi All,

Is there a way to have a "dd-mm-yy" date format on Aggregate instead of Sat May "13 00:00:00 UTC 2006" I already searched for this on this forum; however, probably missed the answer for it. Help on this will be appreciated.

Thanks,
Imran

Hi, @A.N.M_AL-IMRAN!

Currently there is no way to directly configure Aggregate to use a custom date/time format, but you can get a similar effect by changing the regional settings of the server where Aggregate is deployed.

Next releases of Aggregate (and other parts of the ODK stack) will be normalizing all date/time output to the standard ISO8601 format, but I can't be precise about the timeframe for that.

2 Likes

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') |
+-----------+-------------+-------+------------------------------------+
5 Likes