I use Excel Query Wizard to connect to a SQL server to get data. I return an invoice date, but the date is stored as "YYYYMMDD" integer.

Is there a way I can modify the query to recognize the date as a "MM/DD/YYYY" format? I know how to write formulas in Excel that will give me the result, but I want to do it in the Query, so I don't need formulas.

Perhaps I can modify the SQL statement (I've never used SQL).

Thanks-aldsv