Select between today and 7 days ago
Posted on 2005-04-22
I saw this in a previous question
when you use
Select * from empmaster where empDate between '1/20/2003 00:00:000' and '1/29/2003 23:59:000'
to select records between two dates...
I have a table setup that has cdate setup as a coloum which stores all my dates in the format date('d/m/Y'), so I could do
$datestart = date('d/m/Y') - 7; ?
$dateend = date('d/m/Y');
Select * from empmaster where empDate between '$datestart' and '$dateend'
To show all the enteries in the last week?