Sorting by date does not recognise year
-
Hi Tobias,
Sorry to hassle you again so soon with another question!
I use the row_order sort shortcode to sort a list of events into date order with the sort date in US format in a hidden column. I do all the date conversions in an excel sheet which I then import with all the table data.
ie – row_order=sort row_order_sort_column=E row_order_sort_direction=ASC hide_columns=5
This has worked perfectly well with dates where yyyy =2019. When I included dates for events in Jan Feb 2020, ie yyyy=2020, these cells were placed first at the top of the list, as if they were dates in 2019. When I just changed the dates in the sort column to dates at the end of 2019, 12/25/2019 and 12/31/2019 the cells were sorted in the right order. It seems as if the year is not being used?
Am I missing something here perhaps?
Appreciate your help as always,
Many thanks,
Cecil
The page I need help with: [log in to see the link]
- The topic ‘Sorting by date does not recognise year’ is closed to new replies.