title: Exclude weekends between a date range
body: <p>I have the following query and I am trying to select all records between a date range but I want to exclude weekends...anyone know if this can be done?</p>
  
  <p>SQL isn't my strong point!</p>
  
  <p>Below is the query;</p>
  
  <pre><code>SELECT
      tblTime.*,
      tblProjects.fldProjectDesc,
      tblProducts.fldProductID,
      tblProducts.fldProductDesc
  FROM (tblTime
  INNER JOIN tblProjects
      ON tblTime.fldProjectID = tblProjects.fldProjectID)
  INNER JOIN tblProducts
      ON tblProjects.fldProduct = tblProducts.fldProductID
  WHERE fldUserCode = 'pac'
  AND fldDate BETWEEN CONVERT(varchar, '13/11/2015', 103) AND CONVERT(varchar, '15/11/2015', 103)
  ORDER BY fldDate
  </code></pre>
  
  <p>Thanks for any help!</p>