change date type in model

[nfldbunker]

hi

i am trying to change the date type of an item in the  framework manager from carchar to int but when i try and pull down on datatype to be changed it is grayed out...any odeas

bunker

[CognosPaul]

The data type of an item is inherited from the database. Make your change there and refresh the query. It should update to the correct type.

If for whatever reason you can't make the change in the database, you could make a new query item to cast it to the correct type. The downside is the casting is an extremely costly function and will slow everything down.

[blom0344]

The data type of an item is inherited from the database. Make your change there and refresh the query. It should update to the correct type.

If for whatever reason you can't make the change in the database, you could make a new query item to cast it to the correct type. The downside is the casting is an extremely costly function and will slow everything down.

I will be costly if it means that you lose index based access to data, otherwise it is hardly a performance issue