AnsweredAssumed Answered

DateDiff wrong calculation

Question asked by Vit_Posel on Nov 9, 2016
Latest reply on Dec 9, 2016 by Danpego

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.



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.