Hi,
After some advice please. I am using a left join with Max=0 as need to find some events over a 24 hour period, however a user may have more than one event in the subsearch but i need to match on the closest time to my main search.
Not sure what's the best approach to make that match?
Lee
... View more