0 Replies Latest reply: Oct 20, 2011 6:00 PM by Tony Hollywood RSS

    Setting flags

      Hi

      I have a Master Calendar (based on PITR example) that is used to select date range.

      Includes dates:

           Date

           SalesDate

      I have Sales Data that includes:

           SalesDate

           ProductCode

           Product-CreatedDate

           OrderedDate

       

       

      Could you please guide me as to how I can achieve (flag?) settings in my script, so that I can (for example)

      - count the number of distinct products that were created in the selected date range (new products)

      - count the number of distinct products that were created outside of the selected date range (old products)

      - count the number of distinct products created in the selected date range and that were ordered in the selected date range (new products ordered in this date range).

      Many thanks