title: Access: Compare two datetime values with query
body: <p>Please help me to compare two datetime values with <strong>WHERE clause</strong> in access.</p>
  
  <p>Problem is one datetime format is in <strong>German e.g 12.03.2015 4:33:40 PM</strong> 
  while other is in <strong>US format 12/3/2015 4:33:40 PM</strong>.</p>
  
  <p><strong>What i tried:</strong></p>
  
  <pre><code>SELECT *
  FROM Contacts
  WHERE (((Format([Edit Date],"mm/dd/yyyy hh:nn:ss AM/PM")) &gt; #11/28/2016 12:31:30#));
  </code></pre>