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”