The columns in excel are string so the dates are left justified and i have to perform a "TEXT TO COLUMN" to convert the date to date format (or press F2 and then enter on each field - too much to do this manually). This then means our dashboard is not picking up the dates until someone goes into and converts the data to date.
If i had dates in mm/dd/yyyy format the data comes across as dates and everything is ok.
I think the issue is i need to tell the VIEW in sql that the dates are in the format of dd/mm/yyyy.
I thought SET LANGUAGE would do it but that cant be used in a VIEW