3 Replies Latest reply on Dec 16, 2016 11:58 AM by Matthew Risley

    Date Calculation not working on some rows

    Alex Hartley

      I have this date calculation to calculate number of days from when the order was requested and when the order was received:

       

      DATEDIFF('day',max([RQST Date]),MAX([RCVD Date]))

       

      it works in most of the rows, except for a couple. For example, in one of them, the date requested was 6/29/2016 and the date received was 10/17/2016. the result I get for that one is -365,133. First of all, it should be positive because the end date is after start date, and second, why such a large number? the calculation is accurate on the other rows but not this one. Any ideas of what could be causing this?

       

      Thanks