2 Replies Latest reply: Sep 7, 2016 11:23 AM by Mike Sawyer RSS

    'Count' question

    Mike Sawyer

      Hi,

       

      I'm trying to count distinct records that fall within a date range.

       

      So, I have the following 3 variables:

       

      • PS# (which is a unique store identifier)
      • Today's Date
      • Opening Date

       

      I can calculate 'Days To Open' with the formula ([Opening Date]-Today()), and since some PS#'s have already opened, the "Days To Open' field can be a negative number.

       

      What I want to do is count the number of unopened "PS#" that will open within the next 30 days.  That is, 'Days To Open' is greater than 0, but less than 31.

       

      What is the proper Count function expression to do this?

       

      Thanks!