<https://stackoverflow.com/a/14922447/1568948>
# generalm
michoel
06/11/2019, 8:53 PMc
C W
06/11/2019, 9:25 PMthanks but this is returning the dreaded ” ERROR: Invalid Expression ” since this is a SQL statement rather than a case statement, even cutting out just the case statements still errors unless I am doing it wrong
C W
06/11/2019, 9:25 PMideally it works the same as networkdays in excel
m
michoel
06/11/2019, 11:20 PMIt works for me (after changing
CompleteDate{today}InstallDatetrandatemichoel
06/11/2019, 11:20 PM(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)c
C W
06/12/2019, 2:30 PM@michoel dude thank you so so so much
C W
06/12/2019, 2:30 PMworked beautifully
4 Views