title: compare date/time via VBA with date/time in Access DB
body: <p>How to compare a date/time via VBA with a date/time in an Access DB?</p>
  
  <p>The query I use</p>
  
  <pre><code>adoRS.Open "SELECT * FROM currentpositions WHERE ((currentpositions.
  [dateLT])=" &amp; "#" &amp; date_from_message &amp; "#" &amp; ")", adoConn, adOpenStatic,
  adLockOptimistic
  </code></pre>
  
  <p>I only achieve to compare a date.<br>
  Anybody an idea?</p>
  
  <p>Regards<br>
  Camastanta</p>