So why can't I get this to work?
I want a query that will return records made within the last 48 hours.
I'll use a field called date_added that records the date the record was made using now().
I need something like this:
<cfset today = now()>
<cfset twodaysago = today less two days>
<CFQUERY NAME="newphotos" >
SELECT *
FROM mytable
where date_added > twodaysago
</CFQUERY>
I think this could work, but I'm not getting the <cfset twodaysago = today less two days> part to work.
Or, there is a better way?
Jeff
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
