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

    datediff is giving wrong calculations in some cases


      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])






      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.