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

Dates_Need to Exclude weekends

Started by Kiran Kandavalli, 18 Aug 2017 12:42:29 AM

Previous topic - Next topic

Kiran Kandavalli

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