How to sort by a date string

I have a tag whose values are dates in the following format

DDMMMYYYY, Eg: 23APR2020

When I select tag values from influxdb with the below query, values are not returned in ascending or descending order. Please advice me on how I can get values returned in ascending order.

SHOW TAG VALUES ON “database” FROM “measurement” WITH KEY = “expiry”