4 Replies Latest reply: Jun 14, 2017 10:06 AM by Silambarasan Manickam RSS

    Comparing Current day record with previous day ??

    Silambarasan Manickam

      Hi All,

       

      I have a table like below mentioned.

       

      DateItem
      4/1/2016A
      4/1/2016B
      4/2/2016B
      4/2/2016C
      4/3/2016C
      4/3/2016D
      4/3/2016E

       

      on 1st april, A, B Items are available, On 2nd A item is not available. So, i need a status In Active. But new record C added on 2nd. So, for that i need a status Active. So, i need a final result below mentioned.

       

        

      DateItemStatus
      4/1/2016A
      4/1/2016B
      4/2/2016BNotActive(A)
      4/2/2016CActive
      4/3/2016CNotActive(B)
      4/3/2016DActive
      4/3/2016E

      Active

       

      Thank you