SQL Date Comparison

[ASPProgramer]

How do I run a query to take all records from my table that are no older than seven days. A Date field has the system date from the insert and is formatted like 9/21/2000 10:00:50 AM.

I want to display all records from the last seven days. any suggestions would be helpful.

Thanks,

 

[foxdev]

select * from MyTable where DATEDIFF(day, MyColumn, GetDate()) <= 7 [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br> [/sig]