Issue Summary

This issue occurred after Confluence 8.7.1 introduced the ability to sort table contents inside the editor mode (CONFSERVER-28787). Dates aren't sorted correctly in the table of edit mode if the month is different in the date data. 

content type	in View mode	in Editor mode
number	can be sorted correctly	can be sorted correctly
Date	can be sorted correctly	can't be sorted correctly

This is reproducible on Data Center: (yes)

Steps to Reproduce

1. Create a page in Confluence.
2. Insert a table to the page. 
3. Insert the date that one of the dates is in a different month. For example, insert the date in the table below:

   number	date
   1	02 Sep 2024
   2	16 Sep 2024
   3	01 Oct 2024

   Either enter the date in a text or use // to insert the date, and you will get the same result. 

4. Click the Sort Column button to sort the Date data. The Date data are not sorted correctly, as shown in the screenshot below. 
   

Expected Results

The date should be sorted as shown in the screenshot below:

Actual Results

The Date data are not sorted correctly, as shown in the screenshot below. 

Workaround

Sorting the data in the view mode instead of editor mode could show the correct order.