Cannot sort in ascending order

Hi pang22 

 

Based on the information you provided, I ran the following tests:

The following picture shows what you are experiencing.

 

Then change the Data type of the column to date.

 

Click yes.

 

Then select yyyy-mm in the format drop-down menu.

 

 

Is this the result you expect?

 

Best Regards,

Community Support Team _Yuliax

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.