This content has been marked as final. Show 2 replies
I'm trying to count distinct records that fall within a date range.
So, I have the following 3 variables:
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?