DATEDIFF / MySQL Question

[Patrick GH]

I have a query where I am trying to get all records from a data table (TIMELOG) that have happened (EVENTTIME) in the past 7 days or less.

The table name is TIMELOG and the field name is EVENTTIME.

I want all records where EVENTTIME is in the past 7 days or less.

SELECT * FROM TIMELOG
WHERE
#DateDiff("d",EVENTTIME,now())# < 7

I don't know why this doesn't work.
I get this error message
Variable EVENTTIME is undefined. 

[Patrick GH]

I figured it out. Thank you all

[BKBK · Accepted solution]

You were getting the error because EVENTTIME, being a database column, is unknown to ColdFusion. A simple solution is to use MSQL date functions:

SELECT *
FROM TIMELOG
WHERE DATEDIFF(CURDATE(),EVENTTIME) < = 7

[Patrick GH]

This is exactly what I did BKBK. Thank you