15 Replies Latest reply: Jul 21, 2015 4:41 AM by Amit Saini RSS

    Date Cound Help based on Year and Month selection

    Amit Saini

      Hi Folks ,

       

       

      Below are my Year and month filter:

       

       

      Requirement: I'm having a filed called DOH (which is having date inside it) , like below:

       

       

       

      DOH

      Oct, 09 2015

      Feb, 11 2014

      Sep, 08 2014

      Oct, 14 2014

      Apr, 26 2015

      Aug, 30 2015

      Feb, 02 2015

      Apr, 25 2015

      Mar, 06 2015

      Aug, 25 2014

      Aug, 25 2015

       

      Jul, 11 2013

       

       

       

      I want to calculate count of DOH based on Year and Month selection.

       

      For example suppose selected Year = 2015 , Month = Apr

       

       

      so i should get count output = 2 ( See the red text in DOH) ---> count should change based on selection of Year and Month

       

       

      Kindly suggest what should be the expression  for this requirement .

       

       

      Thanks,

       

      AS