Is there a way to use IS NOT NULL as one of the join conditions on a lookup?
I want to get the TOP (1) record where a field is not null, ordered by date.
Currently I have to edit the _Clean stored procedure as custom code to add it, which is obviously not the best way to do things.
Thanks