query using BETWEEN on date field not working

[jim.davidson]

I'm trying to query a table that has a date field lableld created_sort.

 

Here's the query

SELECT needs_id, email_id, status, name, email FROM needs WHERE created_sort BETWEEN 2010-07-01 AND 2010-08-05

 

I know there are two records that fall between those dates but the query comes back empty.  What's wrong with my query?  Any help will be greatly appreciated.  I've been fighting with this for hours.

[Mchl]

Put dates in quotes, otherwise MySQL will do the substraction (2010-07-01 = 2002)

 

SELECT needs_id, email_id, status, name, email FROM needs WHERE created_sort BETWEEN '2010-07-01' AND '2010-08-05' 

[jim.davidson]

Thank you very much! that's all it needed.

[Mchl]

Note: You can also use YYYYMMDD format without quotes.

SELECT needs_id, email_id, status, name, email FROM needs WHERE created_sort BETWEEN 20100701 AND 20100805