I have a custom record with 2 dates (end date and next date) and i need to search for all records where next date is greater than end date. How do I do that with saved searches?

can probably just do a formula(numeric) filter case when {nextdate} > {enddate} 1, else 0 end == 1 do it as a column first and verify the 1s and 0s are appropriate

thank you

Alternatively, Formula (Numeric): {nextdate} - {enddate} greater than 0 Would agree with adding it as a column, to confirm the values produced are as expected, regardless of formula

excellent thanks