Ordering column in date format not working

Ordering a column (date format) not working properly. Below are the two cases of sorting in ascending and descending order. Both seems to be not working properly.

Metabase Version: 0.36.3
Diagnostic Info:
{
"browser-info": {
"language": "en-GB",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.105 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "Java(TM) SE Runtime Environment",
"java.runtime.version": "1.8.0_171-b11",
"java.vendor": "Oracle Corporation",
"java.vendor.url": "http://java.oracle.com/",
"java.version": "1.8.0_171",
"java.vm.name": "Java HotSpot(TM) 64-Bit Server VM",
"java.vm.version": "25.171-b11",
"os.name": "Linux",
"os.version": "4.14.104-95.84.amzn2.x86_64",
"user.language": "en",
"user.timezone": "Etc/UTC"
},
"metabase-info": {
"databases": [
"athena",
"mysql",
"googleanalytics"
],
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MySQL",
"version": "5.7.30"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.5.1"
}
},
"run-mode": "prod",
"version": {
"tag": "v0.36.3",
"date": "2020-08-04",
"branch": "release-0.36.x",
"hash": "a792f14"
},
"settings": {
"report-timezone": "Asia/Calcutta"
}
}
}

Hi @outlier
I’m guessing this is on the dashboard?
Which database are you getting those results from?
What is the column type and Field Type?
Can you post the CSV export of the same results?

Hey @flamber Thanks for the quick revert.
Yes, this is on the dashboard.
Database is “Athena”
Column type is “Date” & Field type is “Creation Date”
Not able to find an option to attach a CSV file.

@outlier
But you can post CSV output instead of attaching.
My first guess is that it’s related to Athena driver. Which version are you using?