title: sql server find date difference in days input date format is dd/mm/yyyy
body: <p>I am developing one project for which i want my date format in <code>dd/mm/yyyy</code> (Indian Format/ British Format). In my Database Table i have used string data type for this field.</p>
  
  <p>I have 2 fields In_date and Out_date through these I am calculating Total_days.</p>
  
  <p>Now I want to calculate difference between these 2 dates in days. The default format of SQL Server is <code>mm/dd/yyyy</code>. whenever I execute     </p>
  
  <pre><code>select Datediff(DAY, 'In_date', 'Out_date') from Table;
  </code></pre>
  
  <p>it gives me error Error converting date from/to string. but when i execute </p>
  
  <pre><code>select Datediff(DAY, '05/28/2013', '05/26/2013') from Table;
  </code></pre>
  
  <p>it gives me perfect answer.</p>
  
  <p>Please help.</p>