Filter ordering with date values

Hi Team,
I have column snapshot_date (string) format dd-mm-yyyy. i have created filter using this column & applied ascending order but its not working properly. (Refer attachment)

@PraveenJadhav this is technically sorting properly because from a string perspective this is the ascending order of the characters. If you’re looking for proper date sorting you should switch the format back to yyyy-mm-dd.