COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: Kiran Kandavalli on 18 Aug 2017 12:42:29 AM

Title: Dates_Need to Exclude weekends
Post by: Kiran Kandavalli on 18 Aug 2017 12:42:29 AM
Hi,

I need to show the List Headers with Dates - Excluding Weekends as in the attachment. Can someone suggest me how to implement in Report Expression.

Currently I am using the below Syntax, but it doesn't exclude weekends.


_add_days (date2timestamp (Today ()),-1)
_add_days (date2timestamp (Today ()),-2)
_add_days (date2timestamp (Today ()),-3)
_add_days (date2timestamp (Today ()),-4)
_add_days (date2timestamp (Today ()),-5)
_add_days (date2timestamp (Today ()),-6)
_add_days (date2timestamp (Today ()),-31)
_add_days (date2timestamp (Today ()),-59)


Thanks!
Kiran