2 Replies Latest reply: Feb 13, 2015 4:50 PM by Nandkishor Pandirkar RSS

    Set Analysis comparing month year from multiple date field

    saurabh singh

      Hi All,


      i am stuck with a set analysis expression in which i want to compare the  max month and year from a date field, being same as  month and year from another date field,


      field1                 field            ID

      2/2/2015          2/3/2015          1

      2/2/2015          1/3/2015           2

      2/1/2015           2/5/2015          3

      1/1/2015           12/26/2014      4

      12/23/2014        10/23/2014     5



      So in the above case Feb 2015 is max in field1 so we want to count ID having Feb 2015 in field, so the count will be 2.


      Thanks for Help