troubleshooting Question

cfquery - finding records older than 24 hours with an exception (slight change to previous question)

Avatar of Judy Deo
Judy DeoFlag for United States of America asked on
Web Servers
2 Comments1 Solution273 ViewsLast Modified:
i have the below query that gets records that have the value of 'Submitted By Customer' in the status field and the date in the RFQ_Date field is older than 24 hours.

<cfquery name="GetUnconfirmedLeads" datasource="dsname" dbtype="ODBC">    
     SELECT id FROM Sales_Leads
     WHERE status = 'Submitted By Customer' AND Now() > DateAdd('h', 24, RFQ_Date)          
</cfquery>

I am trying to put in an exception that says do the above, BUT don't count the time between 5 p.m FRIDAY PST and before 8 a.m MONDAY PST?

and by don't count i mean if a lead comes in at 3 p.m PST on friday, then on monday at 8 a.m, for our purposes only 2 hours have gone by. but in reality over
3 days have gone by.
ASKER CERTIFIED SOLUTION
wytcom

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros