Setting up time field

[gatorfe]

I am trying to bring in a transaction time field from the erp system into cognos.  It is setup as military time in the erp system.  I have the field set up as a numeric data type in sql and as an attribute in fwm.  The results I get when I add the field to a report is not the times I see in the erp system. When I preview the data in data manager it shows the data in time format there though.  I changed the data type in sql to timestamp and then casted the field in fwm as a new calculation but it did not work, cast([dbo].[history].[time], timestamp).  Any suggestions?  Thanks in advance.

[blom0344]

Check the SQL generated. Cognos has the nasty habit of adding min/max functions on objects defined as attributes in some cases.