help in sql query

[houssam_ballout]

hello all,
CAn u help me in the query, that returns certain fields between 2 dates?
thanks

 

[codeman0013]

Yea thats a pretty simple one what are the names of the tables and fields and what do you want to return...

 

[houssam_ballout]

Table -> order
fields -> name, count
I have tried this
select name, count from order where orderDate between '26/11/2006' and '28/11/2006'
but it is returning 0 fields.....
any help

 

[codeman0013]

This is a stupid question but you do have orderDate as a field right? Also you need to pull the order date somehow too..