If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to get number days b/w 2 dates excluding Sat & Sun in Cognos8.4.

Started by ChTripathi, 13 Jul 2011 02:19:33 AM

Previous topic - Next topic

ChTripathi

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?