title: Date format on INSERT statement
body: <p>The following SELECT statement works and returns the date in the correct FORMAT.</p>
  
  <pre><code>SELECT 
  ' - '+c.[customercli] 
  ,c.[customerlookup]  
  ,c.[customername] 
  ,c.[linedescription] 
  ,c.[Sum of buy price] 
  ,c.[Sum of sell price]  
  ,c.[qty] 
  ,c.[Billingmonth] 
  ,FORMAT([FromDate],'dd/MM/yyyy') 
  ,FORMAT([ToDate],'dd/MM/yyyy') 
  
  FROM [MasterBill].[dbo].[DaisyCallsCurrentBill] c
  </code></pre>
  
  <p>But when I run the following INSERT / SELECT statement, I get the following error.</p>
  
  <p>"Conversion failed when converting date and/or time from character string."</p>
  
  <pre><code>INSERT INTO [MasterBill].[dbo].[CurrentBillMaster]
  ([identifier]
  ,[customer id]
  ,[customer name]
  ,[description]
  ,[buy price]
  ,[sell price]
  ,[qty]
  ,[Billingmonth]
  ,[FromDate]
  ,[ToDate]) 
  
  SELECT 
  ' - '+c.[customercli] 
  ,c.[customerlookup]  
  ,c.[customername] 
  ,c.[linedescription] 
  ,c.[Sum of buy price] 
  ,c.[Sum of sell price]  
  ,c.[qty] 
  ,c.[Billingmonth] 
  ,FORMAT([FromDate],'dd/MM/yyyy') 
  ,FORMAT([ToDate],'dd/MM/yyyy') 
  
  FROM [MasterBill].[dbo].[DaisyCallsCurrentBill] c
  </code></pre>
  
  <p>The FromDate and ToDate on both tables are configured with a type of "date"</p>
  
  <p>Any help greatly appreciated.</p>
  
  <p>UPDATE: the date is in the following format on the [dbo].[DaisyCallsCurrentBill] table 2014-09-01 - I simply want to change this to 01/09/2014</p>