Integration Agent query to pick period and year at runtime

Summary

Integration Agent query to pick period and year at runtime

Content

We plan to use Integration agent to pull data from on-premise database. The database contains data for multiple years going back 20 years. When we are using Integration agent query to pull data from source tables, how can we make it pull it only for the year and month for which we are running the integration? Say, we trigger the rule from DM to run for Jul-20, how can the query be designed to pull data only for this period?

I looked at the application filter option and it seems the values for the variables should be passed via DM. This means whenever we like to pull data for 3 months, we need to go and update the variable everytime. This is not automated in any way.