Skip to main content
W
weezerboy
Inspiring
March 17, 2021
Answered

DATEDIFF / MySQL Question

  • March 17, 2021
  • 1 reply
  • 671 views

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. 

    This topic has been closed for replies.
    Correct answer BKBK

    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

    1 reply

    W
    weezerboyAuthor
    Inspiring
    March 17, 2021

    I figured it out. Thank you all

    BKBK
    Community Expert
    BKBKCommunity ExpertCorrect answer
    Community Expert
    March 17, 2021

    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
    W
    weezerboyAuthor
    Inspiring
    March 17, 2021

    This is exactly what I did BKBK. Thank you

      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices