title: C# SQL WHERE DateTime Today
body: <p>I have a database table in Access that looks like this:</p>
  
  <p><a href="https://i.stack.imgur.com/e5owR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/e5owR.png" alt="database"></a></p>
  
  <p>I have a problem with my SQL, I want a 2 <code>WHERE</code>'s in my SQL Statement which I have tried, and it looks like this in server explorer</p>
  
  <pre><code>SELECT Created, [Action], 
         ConnectionLoc, 
         ConnectionSystem, 
         Resource, 
         [Text], 
         RecordId, 
         ToVal, 
         ClientName    
    FROM tblAudit
   WHERE (ClientName = '*Variable*') AND 
         ('WHERE Created'  = '[DateTime].Today')
  </code></pre>
  
  <p>I want only the records with today's date to show.... Hence this bit. Yet nothing is returned. I know the first <code>WHERE</code> is correct since on its own it outputs fine. It's the second one which is wrong.</p>