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.