Sorting order incorrect

[edbs_India]

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

[ThinhDinh]

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

[Jeff_Hager]

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

[edbs_India]

Oops !!! thanks for notifying it.

[edbs_India]

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.