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

Layout Calculation to Concatenate Today's Date

Started by Cognos_Jan2017, 14 Apr 2017 01:17:41 PM

Previous topic - Next topic

Cognos_Jan2017

Running 10.2.2.

Would like to concatenate, in a Layout Calculation, of ...
'Most Recent Incident As Of ' + Current_Date

I know Current_Date has to be converted to a String, but how?  Cast, Extract, ... ?

TIA, Bob

Cognos_Jan2017

Got this to work by adding a Block in upper left corner of Report, adding text ...
Most Recent Recordables By Location As Of ...

then a Layout Calculation directly under with ...
ReportDate()

Result ...
Most Recent Recordables By Location As Of ...
Apr 17, 2017 4:10:15 PM

Wasn't a single line concatenation in a Layout Calculation but it will work.

BigChris

You  don't need to specifically concatenate the two fields - you can just put a  text item into a block, then put a layout calculation (or a singleton for that matter) to the right of it.

Cognos_Jan2017