4 Replies Latest reply on Mar 22, 2018 6:26 PM by swaroop.gantela

    DATEDIFF between two lines

    Kirk Barnett

      I'm using this code below to try and send the results of the time between two dates and it's just sending back 0.

       

      ZN(DATEDIFF('day',IF CONTAINS ([Status],'REC') = TRUE

      Then [Date]END, IF CONTAINS ([Status],'DEL') =TRUE

      Then [Date]END))

      Seems simple right? Just tell me the difference between the two dates?

      I have to be missing something here.

      Thanks in advance for any help.

      Simple code is:

      DateItem Number
      Status
      1/22/2018123Recieved
      1/24/2018123Delivered