(using ms access database)
hi, i have the following cfquery:
<cfset currentdate = Now()>
<cfquery name="GetLeads" datasource="dsname" dbtype="ODBC">
SELECT * FROM Leads
WHERE status = 'Received By Dealer'
ORDER BY ID DESC
i am trying to change this cfquery so it also does a date comparison with the 'date_submitted' field that is in this 'Leads' table.
specifically, i am trying to have it check when status equals 'Received By Dealer' AND the current date (i.e 'currentdate') is not greater than
24 hours after the date it was submitted (i.e 'date_submitted').
how do i add this?