Date Calculation (Today - 1)

[dbrooks74]

I'm on an older version of report studio and unfortuantely I cannot use the built in functions of _add_days.  Does anyone know how to do a calculation for Today()-1?  I can use the today function but when I add the 1 or -1 it does not work.  Any ideas are greatly appreciated.

-db

 

[dbrooks74]

Just wanted to clarify one thing.  I noticed that I can use the built in functions of:

 _add_days ( current_date , -1 )

but I have to do this within a calculation of a list.  I cannot use the built in function on normal text boxes within the page header.  Anyone else run into this before?

Thanks
 

[dbrooks74]

Crazy workaround...but it works for now.

1.  Since I can use the necessary functions in the list of the report I added the field I needed then made the font and border white so it does not showup on the report.
2.  Put a name down in the ID tag of the field so I could reference that field.
3.  Added a "Layout Component Reference" to the report header and put in the name of the ID tag from the report.

Still hoping someone has an easier way to do it but this works for now.

[MFGF]

Hi,

You can simply:

1. Add a data item to your query containing the relevant expression _add_days(current_date, -1)
2. Add it as a property of your list (select the list object, then go to the Properties property and check your item)
3. Define the query as a property of your main report page (select the page and use the Query property)
4. Reference the item in a layout calculation in your page header.

If you are on ReportNet, omit Step 2 as this was introduced for Cognos 8.

Best regards,

MF.