Sorting order incorrect

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

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

1 Like

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

1 Like

Oops !!! thanks for notifying it.

1 Like

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.