I have created a domain with a derived query. I am using CA PPM 14.2
I want to display the a date field retrieved by substracting its value by 1.
Can you please let how this can be achieved.
Thanks in Advance.
If you want to restrict the date in domain then while in the SQL you need to. If you want to get that modified in reports then using formula in reports you can do it.
Thank you for the information.
Can you let me know where can i applyformula for report.
Because i tried modifying in Calculated field, but didnt find any function to substract 1 day from the date retrieved from database.
See if this helps you
Creating a Calculated Field | Jaspersoft Communit
But i can't ifnd any function that could be applied on Date Format directly.
Can you let me know how i can use it in SQL, because i tried with varioud formats but it didnt support in derived query.
Retrieving data ...