in my opinion the cleanest solution is to
1) add a field in the script
Year(ModEffDate) AS ModEffYear
2) Change your Action: Select in Field: ModEffYear. the search string is OK
This will solve your problem.
In alternative probably it can be done without adding that field... but let's be honest: it is always nice to have the Year field!