Dave,
Thank you !! Works like a charm.
-Patrick




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.

                                
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

                                Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
                                

Reply via email to