Dates. + and - days around it

[mazdaman]

I have the following query (used on an ASP page)
------------
SELECT *
FROM volunteer
WHERE qualification='qual' AND AvailabilitYFrom1=#aval#
---------------
The 'AvailabilitYFrom1' is a date. I want to return the date with + and - 7 days either side of it.

Any body help ??

 

[r937]

use the DATEADD function

rudy

http://r937.com/

SQL Consulting