10-17-2013 12:14 PM
I'm hoping I can write a macro to run the same piece of code a number of times.
I want to run it once per month on the last day of the month beginning June 30, 2012 to June 30, 2013.
Dates always trip me up when I want to have the date update each time through.
I will have a prompt for the user to enter the start date and the end date (in case they want to change the date ranges).
Any help structuring the macro so the month end date changes each pass through would be so welcomed!
10-17-2013 12:25 PM
I think you would want to use the INTNX function, with the alignment parameter set to E.
You could also include this calculation in the %SYSFUNC macro function, and put it in a macro loop to increment to the last day of the next month each iteration of the macro.