Access Date Query

I wasn't sure where I should put this so I apologize if this is the wrong place. I am doing some work on my companies website and am currently trying to add the ability to search through records by Sale Date. I have it almost working except for a few strange dates that are getting though. The webpage is using ASP.NET in C# and here is the code for the WHERE clause of the query:

As you can see there are 2 rows that do not belong there and it is also missing 1 row dated 1/8/2010 which should be showing up. The dates are the only part of the where clause in my testing. Let me know if you need any more information.

I'm not truly familiar to .Net, but it seems to me you've made so many string manipulation when you could use a simple WHERE clause in your SQL statement with something like:

WHERE SalesDate BETWEEN @LowSaleDate AND @HighSaleDate

I guess the first thing to do is to show the resulting SQL statement.

Another important thing: dates are a nightmare, because each RDBMS vendor implements different syntaxes to deal with dates. I wrote an article a couple of years ago about the different date formats used by the most common RDBMS vendors and one of the most common date formats used is YYYYMMDD. You might try that too.

I made all of those string manipulations because the dates are stored in the database as text and on the webpage they are entered as strings. This was done to eliminate the problem where every part was interpreting the date differently and not communicating it correctly. Thus here is the finished query when it is run:

EDIT: I discovered that the problem is with the LowSaleDate as when I just run it with that I am getting those 2 sales below the date that I showed in my first post, so here is the query with just LowSaleDate: