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:
- Updating the Usage to Attribute
- Updating the Formatting so that the Date Style is Short
- Modifying the underlying database view to contain a field that is doing the casting, then reference this field directly in the Query Subject.
The Query Item is still being treated as a Date Time in all of these cases.
Screenshots attached.
------------------------------
Dave Chirayath
------------------------------