Sorting order incorrect


I have tried all the date formats in google sheet, still the sorting is not correct.
Please help.
Jay

Why do you have a “:” in before the year?

Is your sort date the same as the date you are showing in your list?

Oops !!! thanks for notifying it.

Yes, sort date is the same given in sort. I think I am able to solve the problem by creating rollup column in the data model. That is working fine.

Anyways thanks.