Table element - group by date fields

[KatieQuantrell]

Hi,

It would be really useful to be able to use a date or date/time field as a Category field within a table when the table type is set to 'Grouped values'. This would mean a table of unique survey dates etc could easily be created with summary statistics e.g. number of records collected on each day etc being able to be created and linked to other map elements. 

Currently the work around to this seems to be to create a string field containing dates, but this isn't ideal as the dates then appear in numeric order in the list when sorted rather than date order.

[PeterKnoop]

One possible adjustment to your workaround, if you don't mind the format, is to use the YYYY-MM-DD format for your dates, for which alphabetic sorting is equivalent to the desired date sort order.

[KatieQuantrell]

Many thanks for the suggestion. I did update the date format that was being displayed in the list to the YYYY-MM-DD format (using advanced formatting) but as it was still using the underlying date field as the sort by field this didn't alter the sort order.

Unfortunately I can't change the format of the current date field as it needs to be in the existing format to link in with other systems. I could potentially add in a new field with the reformatted date but this doesn't seem ideal.