Cognos 8.3 BI Framework Manager is suddenly forcing all of our date fields to be date time fields. This is breaking solutions that have been working fine for over a year. Framework Manager is not allowing me to change the data type and the format property isn't having any effect at all no matter what settings I change.
We're using Cognos BI 8.3 and a MS SQL 2000 database. The data type in the database is smalldate but Cognos is forcing it to Date Time.
I have tried using cast(*date_field*, DATE) but it seems to break all of the dependant fields in the database.
What could have changed to cause this and how can I change it back?