Hi,
Pls help.
In query, i want to get list of task that has exceed 15days for completion excluding weekends(sat & sun).
Include Mon-Fri as days counted.
using below select:
SELECT TASK_NO, TASKNAME, ACTUAL_STARTDATE,ACTUAL_COMPLETIONDATE, DATEDIFF(dd, ACTUAL_STARTDATE, ACTUAL_COMPLETIONDATE) AS TimeTaken
FROM TBL_STATUS
WHERE DateDiff("d", ACTUAL_STARTDATE,ACTUAL_COMPLETIONDATE) >= 15;
getting all records as output and in field TimeTaken getting ' #Func! '
task_no task_name Actual_startDate Actual_CompletionDate TimeTaken
91799 SalesPlanning 8/16/2018 8/28/2018 #Func!
1673806 SalesCapture 8/17/2018 8/29/2018 #Func!
124486 SalesRelease 8/17/2018 8/27/2018 #Func!
Pls help.
In query, i want to get list of task that has exceed 15days for completion excluding weekends(sat & sun).
Include Mon-Fri as days counted.
using below select:
SELECT TASK_NO, TASKNAME, ACTUAL_STARTDATE,ACTUAL_COMPLETIONDATE, DATEDIFF(dd, ACTUAL_STARTDATE, ACTUAL_COMPLETIONDATE) AS TimeTaken
FROM TBL_STATUS
WHERE DateDiff("d", ACTUAL_STARTDATE,ACTUAL_COMPLETIONDATE) >= 15;
getting all records as output and in field TimeTaken getting ' #Func! '
task_no task_name Actual_startDate Actual_CompletionDate TimeTaken
91799 SalesPlanning 8/16/2018 8/28/2018 #Func!
1673806 SalesCapture 8/17/2018 8/29/2018 #Func!
124486 SalesRelease 8/17/2018 8/27/2018 #Func!