title: ColdFusion Dates before a date
body: <p>I seem to have a brain fart here. I'm trying to show all users that were entered in a database 14 days, or more, before today's date. For some reason I either get everyone or no one, but not the ones I need. Here is what I have. Please tell me where I am going wrong. Thank You!</p>
  
  <pre><code>&lt;CFSET TodaysDate = #DateFormat (Now(), "mm-dd-yyyy")#&gt;
  &lt;CFSET CheckDate = #DateFormat(TodaysDate-14,"mm-dd-yyyy")#&gt;
  
  &lt;cfquery name="getUser" datasource="DNS_Test"&gt;
      select *
      from   Login
      where  DateEntered &lt;= #CheckDate#
  &lt;/cfquery&gt;
  
  
  &lt;cfoutput&gt; 
  &lt;cfloop QUERY="getUser"&gt;
     #getUser.LastName#, #getUser.FirstName# &lt;br&gt;
  &lt;cfloop&gt;
  &lt;/cfoutput&gt;
  </code></pre>