title: Getting the Date only from the SQL GETDATE() function
body: <p>I have seen many different ways to do this but I thought I will share this idea with you all</p>
  
  <pre><code>(DAY(Job_Date) = DAY(GETDATE()) 
  AND MONTH(Job_Date) = MONTH(GETDATE()) 
  AND YEAR(Job_Date) = YEAR(GETDATE()))
  </code></pre>
  
  <p>This will only get records where the <code>job_date</code> column is equal to todays date </p>