Pull data and only choose the item with the nearest date

khaledkherallah · 2020-07-19T21:15:44.662Z

Hello guys! So I’m facing a problem, I’ve created a group that shows the next match (aka the nearest match from the user’s current date). I’m facing a problem to get that constraint, all I can see is <, > & = but anywhere that I can find “nearest date”?

image1017×631 29.9 KB

mikeloc · 2020-07-19T21:49:52.033Z

Hi there, @khaledkherallah… try clicking on Search for Matchs, click More, and select :first item (or it might be :last item… I honestly get them mixed up sometimes), and see if that returns the expected result.

Best…
Mike

khaledkherallah · 2020-07-19T21:54:04.424Z

last item’s date can be later than an item created before it does that make any sense? So it would pull the last entry not the entry with the nearest date!
@mikeloc

mikeloc · 2020-07-19T22:08:52.548Z

I’m just saying I know I’ve had to switch back and forth between those options in the past in order to get a particular record because of how the search is performed.

Anyway, did it work?

khaledkherallah · 2020-07-19T22:10:54.494Z

Nope, it pulls the last entry created, so if I created an entry that have a date later than another entry it would still pull the last one created. But thanks anyways for your trouble.
@mikeloc

mikeloc · 2020-07-19T22:21:03.645Z

Well, for what it’s worth, I just created an example that does exactly what you described in your original post, and adding :first item to the end of the search works like a charm.

Best…
Mike

system · 2020-09-27T21:15:45.177Z

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