title: Importing date data from excel into table with right format conversion
body: <p>I am importing data from excel files into SQL server database. In excel ,Date field are in the format mm-dd-yyyy. Whereas SQL database imports it as yyyy-mm-dd, swapping dates to months.For ex. in excel its 01-12-2018 but in SQL it imports as 2018-12-01.  Hence the dates are incorrect.</p>
  
  <p>Please let me know a way to import it correctly in SQL.
  I am happy to import in both ways : yyyy-mm-dd or yyyy-dd-mm. I just want it to read the date correctly form excel file.</p>
  
  <p>I am using import export wizard.</p>