Sorting Projects by Execution Window incorrect

[er4z0r]

Describe the bug
The list of projects (/rolodex/projects/) does not correctly sort projects by execution window.

To Reproduce
Steps to reproduce the behavior (assuming you have multiple projects with start dates in different years):

1. Go to /rolodex/projects/
2. Select All Projects
3. Click Filter
4. Click on the little triangle in the Execution Window column header

Expected Behavior
Projects should be sorted consistently based on the date of the first day of the project. Irrespective of the chosen date format, the projects should be sorted based on year,month and day in that order.

Example:

We are in July 2022 now, so with the following projects

• Project A starting on 1st May 2022
• Project B starting on 16th May 2022
• Project C starting on 1st June 2021
• • Project C starting on 4th June 2020

sort order for most recent to least recent should be:

• Project B
• Project A
• Project C
• Project D

Screenshots

As you can see the start dates are all over the place 2021 before 2022 , 2020 before 2021 before 2022 again.

Server Specs:

• OS: Ubuntu 20.04 LTS
• Docker version 20.10.17, build 100c701, Docker Compose version v2.4.1
• Ghostwriter v3.0.0, released 22 June 2022

[chrismaddalena]

Thanks for bringing this into an issue, @er4z0r. The screenshot helps a lot. I'm now wondering if the jQuery TableSorter has an issue with the German abbreviations. With all English month abbreviations, the sorting looks good on my end. I need to do some testing with other locales.

It might be time to look for a better solution than TableSorter.

[github-actions]

This issue has been labeled as stale because it has been open for 30 days with no activity.

[chrismaddalena]

For better tracking, I'm lumping the issues with non-English dates under this issue. This is includes #193 and #282. We resolves #193, but these issues are all related to the date parsing tripping over non-English month names or abbreviations (e.g., Dec vs. Déc).

[github-actions]

This issue has been labeled as stale because it has been open for 30 days with no activity.