That worked thanks Jason. Now I'm stuck with some dates I've created to use as a start date when the page loads
$today = date('d.m.Y', strtotime("today"));
$dayInOneWeek = date('d.m.Y', strtotime("+7 day"));
How do I convert them to filter the recordset? Thanks for any help in advance.