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

 

 

-----------------------------------------------------------------------------------

net.sf.jasperreports.types.date.DateRange (Date only)
net.sf.jasperreports.types.date.TimestampRange (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?

 

Thanks,

Samba.

Outcomes