2 Replies Latest reply: Apr 13, 2014 11:35 PM by Ram Asokan RSS

    Min max date based on product usage.

    Ram Asokan

      Hello there folks,

       

      First and foremost, couldn't think of a suitable title for the discussion - am going to try my best to explain the situation in detailed.

       

      Planning on developing a report for a subscription based service. Trying to find out a way to compute/script - usage of the service by customers based on the (no. of days). The script would look something like this:-

       

      Based on (customer) {

           Max(usage date) - Min(usage date) = no. of days using the service

      }

       

      Please advise. Thanks.

       

      Best Regards,

      R