2 Replies Latest reply on Jun 26, 2012 3:46 AM by Ben Shirley

    Date help

    Ben Shirley

      Hi all,

       

      I want to show results based on the fixed range of dates,

      I have a column with Sales Start Date and then another with Sales End Date thus providing the range, (licence windows for those who want to know)

      i then have a column that states Shipped Date (the date i delivered said product)

      i have customer names.

       

      What i want to show is all the dates of delivered products for each customer but only if they are within the Sales Range (licence date) thus eliminating all expired licences dates?

       

      Does that make sense?

       

      Thanks,

      Ben