Code: Select all
$sqlQty = "SELECT * FROM sales_invoice WHERE company = '$company' AND date BETWEEN '$frmDate' AND '$ThruDate' AND payment_status = 'Paid'";this is my code to get fields between two dates..
but i cant get the data if i input two same dates.
for example:
Code: Select all
$frmDate = 2004-02-12
$ThruDate = 2004-02-12let say today is feb 12, i can only get the data for that day if the date i input are 2004-02-12 to 2004-02-13.
what should be my sql statement...? thanks