4 Replies Latest reply: Mar 11, 2013 3:10 AM by Sushil Kumar RSS

    Date Range Selection

    Angad Singh

      Hello Community,

       

      I have this Date Range Table:

      startdateenddate
      06/02/201206/11/2012
      06/12/201206/21/2012
      06/22/201207/01/2012
      07/02/201207/11/2012
      07/12/201207/21/2012
      07/22/201207/31/2012
      08/01/201208/10/2012
      08/11/201208/20/2012
      08/21/201208/30/2012
      08/31/201209/09/2012
      09/10/201209/19/2012
      09/20/201209/30/2012

       

      I have two other fields named ProductDate and ProductID's, I need to find COUNT of ProductID's for ProductDate between startdate and enddate of above table.

       

      startdateenddateProductCount
      06/02/201206/11/2012
      06/12/201206/21/2012
      06/22/201207/01/2012
      07/02/201207/11/2012
      07/12/201207/21/2012
      07/22/201207/31/2012
      08/01/201208/10/2012
      08/11/201208/20/2012
      08/21/201208/30/2012
      08/31/201209/09/2012
      09/10/201209/19/2012
      09/20/201209/30/2012

       

      I have used hardcoded =count({<ProductDate={'>=06/02/2012<=06/11/2012'} >} ProductID) and this gives correct results, I am unable to link this with the above Date Range Table.

       

      Please if anybody could guide me for this.

       

       

      Thanks,

      itsangad