5 Replies Latest reply on Jul 24, 2018 12:14 PM by Naveen B

    datediff is giving wrong calculations in some cases

    nikhil.jog

      I have a datediff calculation as below. It gives correct calculation in most cases. But in some cases it is giving wrong results why?

       

      DATEDIFF('day',[Start Date],[Target Date])

       

      correct

      wrong

       

       

      i created a tabular view. First few rows represent wrong calculations.

      i noticed that in case of wrong calculations, most of them have start date from Q1 of 2018 and end date Q2 and after.