I want to manage a list of publications in LISE and I want to store the publishing date with my items. I'm using a custom field of type "Select DateTime" for this. The publication-date is in the range from 1977 up to today.
But I noticed that sorting for the custom_date went wrong in 2001:
Code: Select all
01.10.2001 01.02.2002 13.04.2002 01.04.1977 02.04.1977
[...]
01.07.2000 13.03.2001 01.07.2001
In the admin-panel of my LISE-instance everything works: When I'm sorting the list of items for my custom_date, then the list is correctly sorted.
Is the alphanumeric-search even in a date-field the normal behavior of LISE or is it a bug in the module?
What can I do to get a correct sorting? I can think of two solutions:
- Load all items and doing my own sorting on this in runtime or
- Saving the date in 3 fields (year, month, day) and using the LISE-sort "orderby=custom_year,custom_month,custom_day" (And telling ALL my editors to enter the numbers with a leading zero... OK, this will not work).
Thanks.