Date is within a range of another date

Need help Database
1

hey all,

I have records of users and I’m trying to filter them according the following criterion:
A user can see all other users if their “Date From” (a field in Users’ table) falls within the range of 1 month before and 1 month after of other users.
So for example, if my Date From is June 10th, I’d like to see all users who have the value of their Dates From between May 11th, and July9th.

So far, I’ve been trying to play around with date range, but to no avail; any recommendations?
Much appreciated in advance.
help

2

Can’t you just do two constraints:

Date From > Current User’s Date From +months -1
Date From < Current user’s Date From +months 1

3

The 2 constraints would both be enforced, right?
the current user’s Date From could be before OR could be after the current cell’s Date From.
I’d like to get either/or to catch all users who meet both criteria :slight_smile:

4

No, only both. Think about constraints like the following (oversimplified):

Working from top constraints down:

First, search for Date From > Current User’s Date From +months -1

Now, use the results of that to apply the following constraint:
Date From < Current user’s Date From +months 1

The result is only the users where date is between the two dates will be shown.

5

Works :slight_smile:
Thanks a lot @georgecollier I had a completely different understanding of those constraints!
Much appreciated!