michoel
06/13/2019, 12:10 AM(TRUNC({today}) - TRUNC({trandate}) ) +1 - ((((TRUNC({today},'D'))-(TRUNC({trandate},'D')))/7)*2) - (CASE WHEN TO_CHAR({trandate},'DY','nls_date_language=english')='SUN' THEN 1 ELSE 0 END) - (CASE WHEN TO_CHAR({today},'DY','nls_date_language=english')='SAT' THEN 1 ELSE 0 END)