I had a similar problem.  For a "schedule" table I was querying the last two weeks of data.  I used two datetime variables one set to the current date and...