Display yesterday's date

[Vick]

Can anyone tell me how can I display yesterday's date in my report heading.


Thanks,
Vick.

[cbortkun]

Create a data item containing the following function:
   current_date - 1 day

Insert the data item in your report heading.

Chuck

[Vick]

Thank You. I will check it out.

Vick

[Anand]

use query caluculation add_days(date,-1)

[blom0344]

You'll probably need to associate the the query that provides the date calculation with the page of the page header. Otherwise the page header will only accept report expressions..

[Vick]

Chuck,
          When I create data item with current_date -1 it gives me following error when I run the report.


An error on or around the position '0'. The variable named '[Query1].[Data Item1]' is invalid.

Thanks,
Vick.

[rockytopmark]

Vick, read Blom0344's post.  Your invalid Variable error is solved if you do what Blom0344 suggests. 

If you are on Cognos 8.3 you can use a Singleton instead

[Gopinath]

Associate the Query to th report Page

Create a query calculation _add_days(current_date, -1)

Display it in the report header