COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: gatorfe on 17 Feb 2010 09:32:08 AM

Title: Date Filter
Post by: gatorfe on 17 Feb 2010 09:32:08 AM
Hello!  I am trying to filter Order Dates from a report greater then 2 days from todays date, so I want to see any Order Dates from Friday onward.  I have done this in the past, or so I thought, but I am not having any success with it today.  Any suggestions would be greatly appreciated.  Thank You!
Title: Re: Date Filter
Post by: eliza_jane on 19 Feb 2010 12:16:55 AM
Try using _add_days function..
Title: Re: Date Filter
Post by: vinu on 19 Feb 2010 03:03:30 AM
Try below in your filter.

[Order Date]=_add_days(current_date,2)

HTH,
Venu