I have an excel spreadsheet with a column formatted in mm/dd/yy format.
I set up a connection to pull this date in from a view in a SQL server database. However, when it pulls in, it appears in the format yyyy-mm-dd. It ignores the formatting of the spreadsheet. If I adjust the view to using a CAST function to format the date the way I want, it works. But I was wondering if there was any other way this can work without using CAST?
In the original table, the field where date is being pulled from is of datatype 'date'.