5 Replies Latest reply: Mar 15, 2015 5:29 PM by Manish Kachhia RSS

    Date in set analysis

      Hi all.

       

      I have 2 different date fields, signup date and usage date. I want to make a count where these 2 date fields are the same ex.

      Customer              Signup date     Usage date         

             A                   01/01/2012       03/01/2012

             B                   02/01/2012       02/01/2012

       

      Thus count(customer) should only give me 1

      Please assist.

       

      Thank you

      J/L