Dates: "Do A Search For" against two fields of the same thing

Need help
1

Okay so i’m getting into dates lately here in bubble, and the issue i’m trying not to have is the following:

I have a “thing” called Customer
Inside of customer there’s a bunch of data types, but two in particular are dates: Next Scheduled Visit (date), and Recent Visit (date)

My Goal is to get a list of Customer’s who’s has NOT had a ‘Recent Visit’ since their ‘Next Scheduled Visit’

What i’m trying to do is compare ‘Recent Visit’ to ‘Next Scheduled Visit’ in the filters of the search, but it’s not letting grab that particular ‘thing’ to compare against:
image

do i need to do another search inside that filter? i’m just not sure :thinking:

This is what i imagine it looking like (if parent group’s thing was actually this current search item)
image

2

Hi there, @taylor1… I believe you need to use an advanced filter on this one.

filter
filter883×419 29 KB

As you probably know, make sure to constrain the search as much as you can so as few things as possible are returned to the client (browser) where the filter will then be applied.

Best…
Mike

1 Like
3

thanks, that works, and super-bonus points for the hyper-accurate example :slight_smile:

1 Like
4

Thanks, Taylor… I do my best… well, when I’m not giving answers like this one, that is. :wink:

2 Likes
5

This topic was automatically closed after 70 days. New replies are no longer allowed.