SQL: How to display records for only 30 days

sql ms-access jet
Stanley picture Stanley · Mar 2, 2009 · Viewed 12.4k times · Source

I tried to use 

SELECT * from Results
WHERE DATEDIFF(d,Date,getdate())<30

But it seem having error with this.

For each record submitted will only display 30 days. May I know if my syntax is correct?

Greatly Appreciated, Stan

Answer

Mitch Wheat picture Mitch Wheat · Mar 2, 2009

Syntax looks OK, but you might need to 'quote' Date:

SELECT * from Results WHERE DATEDIFF(d, [Date], getdate()) < 30

Do you have a column called Date in Results?

BTW, that won't be able to use an index, whereas this will:

SELECT * from Results WHERE [Date] >= DATEADD(d, -30, getdate())

Related questions

How to get id of newly inserted record using Excel VBA?

Seems a common enough problem this, but most solutions refer to concatenating multiple SQL commands, something which I believe can't be done with ADO/VBA (I'll be glad to be shown wrong in this regard however). I currently insert my …

Read More
Multiple LEFT JOIN in Access

I have the following query, which works for MySQL: DELETE `test1`, `test2`, `test3`, `test4` FROM `test1` LEFT JOIN `test2` ON test2.qid = test1.id LEFT JOIN test3 ON test3.tid = test2.id LEFT JOIN test4.qid = test1.id WHERE test1.…

Read More
Table-less UNION query in MS Access (Jet/ACE)

This works as expected: SELECT "Mike" AS FName This fails with the error "Query input must contain at least one table or query": SELECT "Mike" AS FName UNION ALL SELECT "John" AS FName Is this just a quirk/limitation of …

Read More