AnsweredAssumed Answered

CABI 6.2 and ITAM 14.3 Date parameter query

Question asked by Sparasa.1 on Jul 5, 2017
Latest reply on Jul 12, 2017 by Gale_Bacon

I am trying to query assets based on creation date/last update date and no success.


last update date is stored as integer as per ITAM Schema

where Jasper functions DateRange or TimestampRange can't be converted to Integer



----------------------------------------------------------------------------------- (Date only) (Date and Time)



Here is the SQL Query and Error while trying to create a report based on Last Modified date.




Does anyone tried creating report for Assets based on Date fields as Input parameters?