Hello Everyone!
     I hope someone can help because i've been banging my head on my desk about this one.

I have a database with a list of Countywide sponsored events. I would like to retrieve a list of events from todays date up to two weeks from now (i.e. if todays date is jan 1, 2005, i would like to retrieve a list of events from jan 1 - jan 15th.)

is there any way to pull the current date from the server and just add 14 days to it using the BETWEEN statement or do i have to write a script in .ASP to declare variables and concantenate it in my SQL Statement?

Any and all help would be greatly appreciated!

Thank you!

Matt

how about something like
... WHERE (<<datefield>> BETWEEN GETDATE() AND DATEADD(d, 14, GETDATE()))

ok, here is my sql statement:

"SELECT * FROM tblCountyEvent WHERE StartDate BETWEEN " & Date() & " AND " & DateAdd("d",14,Date()) & " ORDER BY DisplayDate"


and here's the result when i do a response.write in .asp:
SELECT * FROM tblCountyEvent WHERE StartDate BETWEEN 4/18/2005 AND 5/2/2005 ORDER BY DisplayDate"

Now the page loads, but no results come up and the table names are correct.

should i have singles quotes around the date fields? if i try that then i get an error - type mismatch

any ideas?

I found the error. All I had to do was add hashmarks to the SQL Statement:

"SELECT * FROM tblCountyEvent WHERE StartDate BETWEEN #" & Date() & "# AND #" & DateAdd("d",14,Date()) & "# ORDER BY DisplayDate"

now the listing works correctly. thank you for your help!

Yes - You do need single quotes around your dates.

huh....you are using MS Access..?


this is a SQL Server forum