Date Problem

Hi,
Having trouble with a report i am trying to create.

i want to create a report showing all entrys to customer table within the last seven days.

how can i do this, each new entry has the date added recorded with it called customerdate

if any one can help that would be great

many thanks.

Assuming you are using MySQL, you can make use of the in-built date functions, particularly DATE_ADD and CURDATE.

SELECT stuff FROM table WHERE customerdate >= DATE_ADD( CURDATE() INTERVAL -7 DAY )

Use DATE_SUB() instead if you are using MySQL

SELECT stuff FROM table WHERE customerdate >= DATE_SUB( CURDATE() INTERVAL 7 DAY )