I have a requirement like this.
Below are the field Names
[Q3 Target Letter Plan YTD Aug]
My Requirement is the Hardcoded Values like Year, Month has to changed dynamically in the script level.
The data will be loaded on 15th of every month.
So it should be Current Month - 1 and the Year should be calculated as Current Year
Need your inputs on this.