Clarity

  • Private Community

  • 1.  DateDiff wrong calculation

    Posted Nov 09, 2016 06:26 AM

    CA PPM 15.1 On Premise

    DB Oracle

     

    Using DateDiff(created_date,conversion_date,"Day")

     

    On development env its working correctly

    on Test and Production not.

    result is multiplied with 365.

     

    Example

    1.11.2016, 2.11.2016 dev=1 tst=366

    1.11.2016, 3.11.2016 dev=2 tst=731

    1.11.2016, 4.11.2016 dev=3 tst=1096

     

    behavior on tst is number of days * 365 + 1

     

    Same behavior is on all DateDiff attributes we have.

     

    Vit



  • 2.  Re: DateDiff wrong calculation

    Posted Dec 09, 2016 03:22 AM

    It seems related to the date formats,

     

    i would say that Clarity is using the american yyyy-mm-dd and your dates are in dd-mm-yyyy.

    Can you verify at oracle/sql server database level?