Sort Filter - Change format from YYYY-MM-DD to DD-MM-YYYY

Need the Item-set page to be sorted by “Date” in Ascending Order (…/item-set/591?page=1&sort_by=dcterms:date&sort_order=asc). The issue is that the entries in Dates properties have their values as DD-MM-YYYY and won’t get properly sorted as I need it to be.

The standard sort just sorts as text, so the format has to be year-month-day as that order sorts correctly with a “naive” 0-9/A-Z sort order.

You might want to explore the Numeric Data Types module, which lets you add values that the system actually understands as dates, so it can sort them properly despite how they’re displayed.

1 Like