[SOLVED] Search between dates

[savagenoob]

I want to search and display results that land between and ON the dates entered into the text fields. I only know how to do the BETWEEN query. How can I modify this to search on and between two dates.

 

$query = "SELECT Amount1RS, SUM(BrokerFee), SUM(TotalCollected), SUM(Commission), AVG(BrokerFee),  COUNT(ID) FROM accounting WHERE Date BETWEEN '$newdate1' AND '$newdate2' GROUP BY Amount1RS";

[PFMaBiSmAd]

 

 

Between IS inclusive of the min and max values used -

 

If expr is greater than or equal to min and expr is less than or equal to max, BETWEEN returns 1

[savagenoob]

hm... OK then Im just a Nub.... Thanks.