title: SQL queries with date format "dd/MM/yyyy " in Microsoft SQL Server Compact
body: <p>I am using SQL serverce(Microsoft SQL Server Compact)
  I have problem with the dates when queering database. I am saving  dates in database into nvarchar fields with this format "dd/MM/yyyy" 
  for example,when I use this statement</p>
  
  <pre><code>select * from ClientAccounts where  clientAccount_Date &gt; '29/07/2019'
  </code></pre>
  
  <p>I get this in result 30/06/2019 </p>
  
  <p>I even tried this format</p>
  
  <pre><code>convert(nvarchar(10),clientAccount_Date,103) &gt; '29/07/2019'
  </code></pre>
  
  <p>I got the same results
  anyone can help me please in this issue.</p>
  
  <p>Thank you in advance</p>