14 Replies Latest reply: Sep 17, 2018 6:26 AM by Hanan Ali RSS

    Less than equal to Selected year and month

    Hanan Ali

      i need to show data until selected year and Month

       

      have Joining date till the selected year moth need to know number of employees

       

      tried build two variables

      1.vYear ==passing selected year

      2. vMonth =passing selected Month

       

      3. concatenation both variables vyearmonth =vYear &vMonth

       

      have column year(joinng date)&month(joining date)  created this column in database

       

      201901

      201902

      201903

      .

      .

      .

       

      used below expression but not working

      =Count(distinct{<yearmonth=  {"<=$(vyearmonth )"}>} empno)

      need urgent

       

      it s beheaving strange