Hi,
I have a requirement that I need to calculate the number of days b/w 2 dates excluding weekends (ie. Saturday, Sunday).
Say there is table and the output that I require.
Name | Start_Date | End_Date | Duration (END_DATE - START_DATE)
---------------------------------------------------------------------
ABC | 07-JUL-2011 | 12-JUL-2011 | 3
Normal subtraction, I will get 5 days, but i need to get the working days (excluding sat, sun). Is there any function in Cognos8.4 which I can use and get the result?