> As you can probably figure out I am very new to this. I tried your query and it did give me a date of three days ago. How would I implement this in my query?
Something like this should be what you're looking for: <cfquery name="Thirdday" datasource="badge_access_dsn"> SELECT * FROM SPS_NON_MOT_BPS.SITES WHERE ((trunc(CREATION_DATE) <= trunc(sysdate-3) AND Badging_status = 'In Approval Cycle') OR (Badging_status = 'In Renew Cycle' AND trunc(MODIFY_DATE) = trunc(sysdate-3)) AND (SUPPLY_MGMT_APPROVAL_STATUS = '' OR M_CONTACT_MGR_APPROVAL_STATUS >= '') </cfquery> The trunc() function will disregard the time portion of the timestamp. One other thing to note is that * queries are bad for database performance and not helpful for developers trying to read your code later on. Try using only the columns you will need in your query instead. Regards, Dave. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
