Code: Select all
// Date the petty cash system started
$startOfCashDate = "2003-10-01";
// The date of the end of last month
$endoflastmonth = $last_year."-".$last_month."-".$lastday."";
$sql = "SELECT SUM(debit_amount) FROM petty_cash WHERE date_spent BETWEEN '$startOfCashDate' AND '$endoflastmonth'";How can i get bwetween and including?
Thanks
Mark