Issue on Formatting date type query items

[ranne_78]

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. Ã,  Ã,