Surprised no one else has upvoted or commented, agreed this is a huge missing feature for reporting. Its a basic operator.
Post
Follow"on or after" condition missing from group options
Hi,
I tried to create a group of people that did not have a sales demo booked after a certain date (on or after the first day of this month).
But note - there isn't an option to do "NOT on or after" a specific date.
So, this is a feature request... but it's also kind of a bug (missing feature that should be there)

Please sign in to leave a comment.
7 comments
Not upvoted because the operator is actually there.
@landon not correct, we need "Not on or after" as an option. (Post title is incorrect but Michael details it in the body correctly)
What is your actual use case for this? "Not on or after the first day of this month" is the same as "on or before the last day of last month" which is available.
Gotcha, with that logic I tried to make this below. I believe our issue is with a Blank value. Wonder if Im thinking of SQL rather than selectors and getting confused, or if this may be a bug.
The group condition we are trying to make in our account is this, but it doesnt pull what we'd expect:

It filters/omits blank cases rather than including. Then If I set the condition to this, it works as expected:

I suspect the "On or Before" cant do "Or blank" conditions?
I suspect 'on or before' can't do multiple OR conditions, despite the interface apparently allowing it. What would 'on or before' may 1 OR 'on or before April 1' even mean? what would you do with April 15?
Gotcha the OR allowing me to choose blank is the main thing. i.e. on before specific date OR blank, is what I need. Is that a bug or a feature request?