I am wondering if anyone has had any luck using a macro or something else that knows that you are in 2009 or (Current Year) and that the month should be thru today. Thus when the app opens it should select 2009 (since we are presently in the year) as the year and Jan - Jun as the Month range.
Obviously as the year goes on it will know to select more dates based on today's date.
Currently we are saving the date range so when it is sent out via publisher, the date range is there; However this is not automatic and relies on someone every month changing the date range...
You can use "if": if <condition here> then <your actions if condition is true> else <your actions if condition is false> end if I can't tell more because it's not exactly clear waht is your condition "the Month is January" (current Month? selected Month?), and what is "go back one year and select all months". Hope you can figure out from here.
Michel, I was thinking thta based on todays date, it would evaluet the month and if todays date was in January, it would go back 1 year and select that year and all 12 months or else it would do the normal routine
