I'm adding a new Query Item in Framework Manager. I am working in CA 11.1.4.
I want this field to be only the date portion of a date-time database field.
The field expression is cast([Audit].[COGIPF_USERLOGON].[TIME STAMP], date)
When I test the data it appears that the field is only returning the date portion, but the Properties of the field still show the data type to be Date Time and when imported into Cognos, it still has the time portion. (though the time portion is all 0).
I have tried the following:
The Query Item is still being treated as a Date Time in all of these cases.