In the Advanced Find, there's no option to set a filter for date fields to specify Today and after. For instance, if you're looking to retrieve all active contracts that will expire on or after today, you can't directly set this criteria in the filter.
Problem
In the Advanced Find, there's no option to set a filter for date fields to specify "Today and after." For instance, if you're looking to retrieve all active contracts that will expire on or after today, you can't directly set these criteria in the filter.
Solution
You can combine two criteria: one for expiry dates that are today and another for expiry dates within the next X years. See the screenshot example below.
Expired Date = Today OR Expired Date = Next X Years where X = 100? I tested this, and it is working as expected.
