COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Framework Manager => Topic started by: ranne_78 on 03 Dec 2006 09:00:27 PM

Title: Issue on Formatting date type query items
Post by: ranne_78 on 03 Dec 2006 09:00:27 PM
Hi

As per our requirement our business users want to display the date type query items into MMDDYY. We are using Mainframe DB2 database. The atual format in Mainframe DB2 database is in YYYYMMDD. When I am trying to format in Frame workmanger Query items and published that package it showing the Database saved format as YYMMDD in query studio report.

The Cognos KNowledge base is saying that create temperory Date item in FM Ã, and format that Date type item.

Is there any possible workaround to our issue.

Help me inthis regard.

Thanks,

Swathi. Ã,  Ã,Â