When you are using dates within queries to specify a time period, you have to use a certain syntax.
The syntax is as follows (including quotation marks):
'YYYY-MM-DD'
For example, the 23rd of April 2010 would appear as:
'2010-04-23'
You will need to use this format in all areas where the Date is entered: