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.

 

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

Outcomes