title: Retrieve Records Less than 90 Days Old
body: <p>I'm trying to use the below code to bring back all records that are not older than 90 days from a table:</p>
  
  <pre><code>Set PlatinumList = db.OpenRecordset( _
      "SELECT FORMATTED_CTN FROM CTN_LIST " _
      &amp; "WHERE ((Status='Available') AND (Category='Platinum')) " _
      &amp; "AND (In_Offer_List = True) " _
      &amp; "AND (DATEDIFF(day, Created_DT, current_date()&lt; 90);", _
      dbOpenSnapshot, dbReadOnly)
  </code></pre>
  
  <p>I keep getting a syntax error in query expression error when I try and run the code.</p>
  
  <p>I think I'm formatting the date section of the code incorrectly.</p>