Date Range +- of todays date

[meltingpot]

Simple Code

SELECT CourseName
FROM Courselist
WHERE CourseName='First Aid' Between#StartDate# AND #EndDate#

There are many First Aid courses that run at random times across the month.

I want to be able to find 'First Aid' courses that are running today and show any running 8 days +- of todays date... Any ides

 

[SkipVought]

Hi,

WHERE CourseName='First Aid' [b] 
  AND [YourDateField] Between Date{}-8 AND Date()+8[/b]

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[meltingpot]

Ive tried but get a syntax error in expression.

BTW - the query is running on an ASP web page connecting to an Access database.

Code I tried ..StartDate is the date field in tbl CourseList
SELECT *
FROM Courselist
WHERE CourseName='First Aid' AND StartDate Between Date{}-8 AND Date()+8

What have I done ?????

Do I need # some where ?

 

[SkipVought]

check out the [red]BRACES[/red] you have rather than PARENTHESES...

WHERE CourseName='First Aid' AND StartDate Between Date[red][b]{}[/b][/red]-8 AND Date()+8

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[meltingpot]

Changed the Braces get error 'too few parameters.Expected 1'

Code Used .....
WHERE CourseName='First Aid' AND StartDate BETWEEN Date()-8 AND Date()+8

 

[meltingpot]

Its working - retyped it all in again, closed the program and it worked fine - Program bug ???

Thanks for the help

 

[SeeThru]

Nope - wrong brachets {} is not the same as ()

!

 

[meltingpot]

Hi see Thru ... the odd thing is it is working great with () ???

Check out 'Courses Running This Week ' on

http://www.jsastc.org.

I used this code
"WHERE StartDate Between Date()-5 AND Date()+5" and was not so happy with Date{} ...

But hey ... it works