Automatic Time Grouping not working with SQL Query source

Hi all! (Apologies if this has been covered already; my search didn't come up with anything, but I may just not grasp how to search for a particular phrase.)

I recently switched an Excel 2016 tab data source from a copy-pasted list to a SQL view. I use a Microsoft Query as an external data source and bring the results into an Excel table. It works great -- except for the dates.

My end users are used to the automatic time grouping for selecting all days in a given year or a given year/month. For whatever reason the table refuses to treat the values in the date columns as Dates.

In the SQL view the field is type date (I've also tried datetime) and I've made sure to format the column as "Short Date", but when I try and filter the column it treats the values like text, with filter options "begins with", "contains" and so forth. Under my External Data properties I've unchecked "Preserve Cell Formatting" and I've selected "Overwrite existing cells with new data, clear unused cells." Didn't help, unfortunately.

Any ideas how to get these dates to behave like dates?

Thanks in advance for your help!

Thanks, dflak! This will solve the immediate problem.

(You also reminded me that I could use MS Access to do transformations on linked tables so that may work as a solution when I've got, oh, six different date fields and don't want to create six new columns.)