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 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.
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') |
+-----------+-------------+-------+------------------------------------+