Hello community
How do I change the date format of the date picker in XLS forms from the default of yyyy-mm-dd to let’s say dd/mm/yyyy
Hello community
How do I change the date format of the date picker in XLS forms from the default of yyyy-mm-dd to let’s say dd/mm/yyyy
The appearance of the date widget is set by the Android system. You can make some adjustments, for example changing it to a spinner format or requesting only year and month. 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') |
+-----------+-------------+-------+------------------------------------+
thanks @danbjoseph ,,,,let me try that