Date values from SQL cannot be filtered in EXCEL

I created a VIEW in SQL which contains a date column. The date column is defined as datetime ,I had to use CONVERT (nvarchar.mydate,103) so I can get the following format : dd/mm/yyyy.

Now when I connect from EXCEL to get this data view,I am getting the date as follow :

bkaya.jpg

I want them to be displayed as years so I have to use the Text to columns option and convert them.

4WwfO.jpg

The problem that I need to do this every time after I refresh the sheet. Is there a way that I can get the date automatically to be filtered by years.

Don't convert it to a string, so remove:CONVERT (nvarchar.mydate,103)

Then just format the column in Excel. It doesn't work since Excel is seeing a string, not a date