Date Data Format

[bi4u2]

Hello, we are on Cognos 8.4.1 and MS SQL Server 2008. I have a date field that is already in the following format '2011-12-31'. When I try to apply any of the Data Format properties, nothing changes. For example specifying a date style Short, Medium, Long or Specifying the Ordering of Month, Day, Year. This column has already been cast to a date from a datetime in Framework Manager.

[Gyana]

Try to cast in the Report level. in Date data item use cast function.
Cast( [data item],date)

[bi4u2]

Yes, I tried to cast in the report as well as the FM. I ultimately went back to the FM model and did a datename function & cast to create a query item that forced the data item to display like 'March 31, 2012'.