I need to build a marketing list with date condition like so:
Month("End Date") = "This month" + 4
Basically, find records with End Date in 4 month
For example, if I pull the list on 6/12/17 - I will get all records with end date in Oct: 10/1/17, 10/2/17, etc
The closest I found is "Next X Month" but it also includes records within 3 month.
As an alternative - I'm exploring a path of creating workflow to update the "query" value of the marketing list record. Unfortunately, it's not possible to add Query field to the default form... this is getting very complex for a simple requirement.
Any ideas would be appreciated!