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
#DateDiff("d",EVENTTIME,now())# < 7
I don't know why this doesn't work.
I get this error message
Variable EVENTTIME is undefined.
I figured it out. Thank you all
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
This is exactly what I did BKBK. Thank you