I have been banging my head against a wall for a while.
I have a table of records in Access. I need to find all the records that
were entered from 3 days ago to right now. This is the code:
<CFSET timing = #DateAdd('D',-3,Now())#>
<CFQUERY name="findRecent" datasource="Categories">
SELECT *
FROM Links
WHERE DateAdded >=
#DateFormat(timing, "m/d/yyyy")#
AND approve=1
ORDER BY DateAdded DESC
</cfquery>
(DateAdded is a date/time field in access with dates formatted as
7/17/2003)
This only succeeds in bringing back every record in the DB. If I change
the "WHERE" line to "=", rather than ">=", I don't get any records (even
though there are several that fit this)
What am I overlooking?
Thanks in advance
Jake
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at
http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
