I have to find diff between 2 dates but 2nd and 3rd saturdays, all sundays should not be considered in the minus operation
Have used macro to find the datediff between the dates also have detected the removable days from the two dates as if the flag, Remove and Keep for the days
the problem is , How should i eliminate those days from the datediff.
Please help me into this, this is the second time i am posting this Qtn.
Mcro used :
function datediff2(d1,d2)
datediff2=datediff("D",d1,d2)
end function
Expression used to detect the days :
if(day(RECD_DATE)/7>1 and day(RECD_DATE)/7<=3 and (WeekDay(RECD_DATE)='Sat' or WeekDay(RECD_DATE)='Sun'),'Remove','Keep') as RECD_1,
its helping to detect the days perfectly but i want to eliminate those while taking the difference in the dates, that will be considered as TAT which is what i exactly have to show
