Skip to main content
Planview Customer Success Center

How to format Cognos date in cross tabulated reports? (CP 2012)

QUESTION:
A cross tab report in Cognos has one of the headers as date. This date value in the header needs to be shown in a special format (without the day, and the month being as text - not as number).

However, the date format selected in Cognos it is not applied to the field.


ANSWER:
The source type of the crosstab date cell needs to be changed. It is by default set to 'Member Caption' and then the date format specified is ignored.

Set the field to 'Data Item Value', then dates can be formatted as required, using the date format dialog.