title: convert to data type DMDATE:datetime
body: <p>I am working on a SQL database and writing a query.<br>
  One condition should restrict data for a date to be between <code>from date</code> and <code>till date</code>, the column data type is <code>DMDATE:datetime</code>,</p>
  
  <p>Query:</p>
  
  <pre><code>Select * from dbo.invoices where invoicedate between dateadd(d, -3, getdate()) and getdate()
  </code></pre>
  
  <p>It's always empty, but I should have data for 3 days ago.</p>