DATEDIFF / MySQL Question

Question

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.

BKBK · Accepted Answer

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

weezerboy · Answer

I figured it out. Thank you all

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.