1 Reply Latest reply on Nov 16, 2014 4:38 AM by Steve Martin

    Datediff function not working

    Jessy Cool

      I am trying to find duration of months between order date and ship date but am getting wrong result..please help

        • 1. Re: Datediff function not working
          Steve Martin

          Hi Jessy,

           

          Please can you elaborate a little more on what it is you are trying to achieve, looking at it, your calc and the subsequent function are working correctly.

           

          I suspect the issue you are seeing is a result of the aggregation, (sum),switching the calculation over to an attribute in an expanded view [order id, mdy order date, mdy ship date calc 10 as text] then filtering to individual year of order date you will find the the numbers make sense.

           

          I've put mine through to a window_avg.

           

          Does this help clear it up a bit?

           

          Steve