Proper column types for dates in excel #981
Description
Hello friends, when exporting dates in excel, they are exported in text columns. This leads to problems for my users when trying to sort these date columns. For example 23/12/2024 and 22/12/2023 will not be sorted properly !
I'd like to discuss possible solutions to this; I've tried various things but the only two viable things I've found are:
- Change the value of the column to YYYY-MM-DD so it sorts fine even as text
- Tell the users to parse the dates using text to columns
Can you recommend anything else or maybe a way that this could be fixed by a patch in django-tables2 ?