9 Replies Latest reply: Dec 12, 2013 8:15 PM by Sumita Chawla RSS

    Count based on date range

    Sumita Chawla

      Hi All,

       

      I am having dataset

      IDDate
      A

      15/10/2013

      B14/10/2013
      C2/9/2013
      D

      4/5/2012

      E7/6/2012

       

      I need the count of id's if it coming in last 15 months from today

       

      For eg in this case my output will be count(ID) = 3 (i.e. A ,B and C)