I have an excel workbook setup, which when opened runs the sql script setup via data connections to sql server and loads the data in.
The problem is to do with date format on excel workbook. It always gets at 'text'
I am working with excel 2007.
I have tried returning the date from my db column as 'Date' datatype, tried setting format in excel as Date, still it gets as text.
When I double click the cell, and press enter, it sorts the date.
The problem with this is that, if its not date, the filters in excel work as 'text filter' and not as 'date filters'
any way to sort this out ?