title: Attempting MS Sql Server Query by TimeStamp/DateTime
body: <p>I am using MS Sql Server Mgt Studio 9.0 and attempting to get a query to filter my IISAccessLogs [dbo.IISRequests] for specific IP access attempts within a specific range.
  If I query my DB with </p>
  
  <pre><code>select * from iisrequests where ClientIPAddress like '192.168.120.%'
  or ClientIPAddress like '192.168.125.%'
  </code></pre>
  
  <p>I get a return that has all the requests in the logs from these addresses; however I want to only view recent activity within the past 14 days.</p>
  
  <p>I have tried </p>
  
  <pre><code>select * from iisrequests where ClientIPAddress like '192.168.120.%'
  or ClientIPAddress like '192.168.125.%' and TimeStamp &gt;= '20130411
  00:00:00'
  </code></pre>
  
  <p>which still gives me a return of all the logs (as did the first run) and I have tried </p>
  
  <pre><code>select * from iisrequests where ClientIPAddress like '192.168.120.%' or ClientIPAddress like '192.168.125.%' and DateTime &gt;= '20130411 00:00:00'
  </code></pre>
  
  <p>which gives me an error </p>
  
  <blockquote>
     Msg 207, Level 16, State 1, Line 18<br>  Invalid
    column name 'DateTime'.</p>
  </blockquote>
  
  <p>My dbo.IISRequests shows </p>
  
  <pre><code> Create Table [dbo].[IISRequests] (
   ~ (obfusicated)
  [TimeStamp [datetime] NULL,
   ~ (obfusicated)
  </code></pre>
  
  <p>In the table output after query my TimeStamp column shows the dates as <code>2013-03-29 08:30:45.0000</code></p>
  
  <p>How do I get this to only return the TimeStamp activity I'm looking for?</p>