DaysSinceFromDate - Only Business days

[Raftsman]

Is there a way only to count business days with this function?

Thanks

[Raftsman]

For those asking how I got it done, I was forced to do it through the Oracle stage.

Sql command

SELECT A.CIMS_NUMBER, PROVINCE, SUBMISSION_TYPE, FILE_OPEN_TIME_ID, FILE_CLOSED_TIME_ID, BUSINESS_DAYS
FROM IMP_ATR_MINISTERIAL_ORDERS A
INNER JOIN (
SELECT CIMS_NUMBER, SUM(CASE WHEN TO_CHAR(B.FISCAL_DATE,'d') IN ('2','3','4','5','6') THEN 1 ELSE 0 END) BUSINESS_DAYS
FROM IMP_ATR_MINISTERIAL_ORDERS A
INNER JOIN LANDSO_MART.TIME_DIM B ON B.TIME_ID BETWEEN A.FILE_OPEN_TIME_ID AND A.FILE_CLOSED_TIME_ID
GROUP BY CIMS_NUMBER, PROVINCE, SUBMISSION_TYPE) B ON A.CIMS_NUMBER = B.CIMS_NUMBER

[chulett]

Probably the best answer. You might enjoy this post, thought of your issue when I read it.