Print Page - getdate() minus 1

Title: getdate() minus 1
Post by: Bourbz on 13 Nov 2007 04:30:53 PM

Hi I am new to COGNOiSe and am seeking some help....

I have conditional formatting on a date field and an wanting to display different coloured text for data that is older than today.

In short, I need to know the coding for TODAY MINUS 1 or 2......

I know this is probably really easy, but I'm stumped.

Title: Re: getdate() minus 1
Post by: Eromac on 13 Nov 2007 04:43:31 PM

Hi, if you're using SQL as DB you can try this
DateAdd(dd, DateDiff(dd,0,GetDate()-1), 0)

Title: Re: getdate() minus 1
Post by: Bourbz on 13 Nov 2007 04:54:13 PM

That doesn't help as I need to do within a boolean.

Is there something I can do around Today() minus 2?

Title: Re: getdate() minus 1
Post by: rockytopmark on 13 Nov 2007 05:08:38 PM

Boolean Expression:

[YourQuery].[yourDateItem] < Today()

If your date item is in the past, then the condition is met, TRUE.

Title: Re: getdate() minus 1
Post by: Bourbz on 13 Nov 2007 05:37:17 PM

Thanks Rocky.

Being that I am in Australia and our warehouse is update with data from US this means I would need today's date minus 2 days, because of the data dely.

Title: Re: getdate() minus 1
Post by: lastsummer on 14 Nov 2007 08:25:01 PM

if using oracle, add a filter [time]<trunc(add_days({sysdate},-2),'dd'),
maybe work

Title: Re: getdate() minus 1
Post by: rockytopmark on 14 Nov 2007 08:35:37 PM

Solution for the Variable Expression we started earlier, you can change date using this getup:

_add_days(date2timestamp(Today()), -1)

... Today is Nov 14, 2007 and it is returning Nov 13, 2007

So now the Variable Expression would be:

[YourQuery].[yourDateItem] < _add_days(date2timestamp(Today()), -1)

Title: Re: getdate() minus 1
Post by: Bourbz on 14 Nov 2007 09:41:49 PM

Thanks Rocky.

Now just have to wait for next data load to check if it's functional.

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: Bourbz on 13 Nov 2007 04:30:53 PM