Clarity

  • Private Community

  • 1.  Operations on DATE Format in Domain

    Posted Apr 26, 2016 03:50 AM

    Hi All,

    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.

     

    REgards,

    Anusha



  • 2.  Re: Operations on DATE Format in Domain

    Broadcom Employee
    Posted Apr 26, 2016 04:41 AM

    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.



  • 3.  Re: Operations on DATE Format in Domain

    Posted Apr 26, 2016 05:09 AM

    HI Suman,

     

    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.

     

    Regards,

    Anusha



  • 4.  Re: Operations on DATE Format in Domain

    Broadcom Employee
    Posted Apr 26, 2016 05:28 AM

    Hi Anusha,

     

    See if this helps you

     

     

    Creating a Calculated Field | Jaspersoft Communit



  • 5.  Re: Operations on DATE Format in Domain

    Posted Apr 26, 2016 06:00 AM

    Hi Suman,

    Thank you.

    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.

     

    Regards,
    Anusha