Selecting recordsets within a week of NOW

gmoney060 · August 17th, 2004, 08:45 PM

How do I select everything from a database were the date is within 1 week of today.... All I would need is the selection statement. O, and the dates in the database are like this "06/07/2004" so I am not sure if you can use the function "now()"... Any help would be great!

om_prakash · August 17th, 2004, 10:55 PM

you can use the following statement:

select * from table_name where your_date between getDate() and getDate() + 7

Hope this helps

Om Prakash

bmains · August 18th, 2004, 07:36 AM

Hey,

What database are you using? If you do it directly in ASP, you can use date, and might be able to do date - 7. If you are doing it in SQL statement, something like above if you are using SQL Server.

Brian