Query for business days
Hello,
I am developing a query for a Accounts Payable report that will inform me if an employee did not submit their report within 25 business days. Something like show me if attribute2 is greater than 25 business days
I think I am making this too complicated. Any help is greatly appreciated.
select distinct
erp.invoice_num,
erp.total,
erp.attribute1,
erp.attribute2,
erp.report_submitted_date,
ppf1.email_address,
ppf.first_name,
ppf.last_name,
TO_DATE(TO_DATE(erp.ATTRIBUTE2,'YYYY/MM/DD HH24:MI:SS'),'DD-MON-RRRR')+25
from
ap_expense_report_headers_all erp,
per_ALL_people_F ppf,
PER_ALL_ASSIGNMENTS_F PAA,