[Bulk Order Management] Incorrect sorting by date: months sorted alphabetically instead of chronologically

[drummer83]

Description

When sorting the orders on bulk order management page by 'completed at' date, the months are sorted alphabetically and not chronologically as you would expect.

Expected Behavior

Sorting ascending by date you would expect: July --> August --> September

Actual Behaviour

It is sorted alphabetically: August --> July --> September

Steps to Reproduce

1. Go to /admin/orders/bulk_management
2. Select date range covering three or more months
3. Sort by date (click on 'completed at' in the table header)
4. Observe the sorting

Animated Gif/Screenshot

Workaround

Severity

bug-s4: it's annoying, but you can use it

Your Environment

• Version used: staged 5a4b38e (master)
• Browser name and version: Firefox 104.0 (64-bit)
• Operating System and version (desktop or mobile): Ubuntu 20.04 LTS

Possible Fix

[adam-rankn]

looks like a good first issue for me to tackle, will look into it

[drummer83]

Welcome @AdamPRankin! Great to have you here!

Let us know if you get stuck!

Looking forward to your contributions! 😊

[RachL]

Hello @AdamPRankin ! I hope this message fins you well. Just checking in: are you still working on this issue?

[toshitapandey]

@RachL - If no one is working on this, can I pick this up?

[RachL]

@toshitapandey apologies for the late answer. If you are still interested yes go ahead, I've assigned it to you!

[cyrillefr]

Hello @RachL , @drummer83 .
Since no one is assigned, may I work on that issue ?

[RachL]

hi @cyrillefr there are some changes going on in BOM atm so perhaps best to wait for these changes to be merge before we fix this. I will indicate the dependency issue 👍

[cyrillefr]

No problemo @RachL , I have the fix on my local machine. I will save it for later.

[drummer83]

Is this one still blocked? #10123 has been merged.

[RachL]

No we are good to go 👍

[cyrillefr]

Hello @RachL & @drummer83,

May I work on this issue ? I made a patch 3 months ago, I hope it is still valid.
I am working on #9499 by now, but I can definitely check if my solution is ok within 2 days.

[RachL]

Hi @cyrillefr yes go ahead 💪 thank you so much :)