Copy link to clipboard
Copied
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.
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
Copy link to clipboard
Copied
I figured it out. Thank you all
Copy link to clipboard
Copied
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
Copy link to clipboard
Copied
This is exactly what I did BKBK. Thank you