I am trying to create a button that will be used on each of the 6 sheets I have on my application. I am trying to set the action of the button so that when clicked, it will select the Last 6 Months from a specific date field.
For example: I have a date - Disposition Date - and when I click the button labeled "Default Value Selection" it will select the last 6 months from Disposition Date. Additionally, if there is a way to dynamically select 6 months from Disposition Date when there are months in the future but I only want to select current month through past 5 months.
How can I dynamically set an expression to select the last 6 months of the newest month is always current month or how to set dynamic expression where there are future months?
