23maverick23
5/1/2014 - 3:19 PM

NS: Project task duration

NS: Project task duration

project_task_duration.sql
content_copyfile_download
(TO_CHAR({enddate},'J') - TO_CHAR({startdate},'J'))+1 - ((((TRUNC({enddate},'D'))-(TRUNC({startdate},'D')))/7)*2) - (CASE WHEN TO_CHAR({startdate},'DY','nls_date_language=english')='SUN' THEN 1 ELSE 0 END) - (CASE WHEN TO_CHAR({enddate},'DY','nls_date_language=english')='SAT' THEN 1 ELSE 0 END)