I am trying to filter on the last three days of a running report (dates
always changing in a twenty day period) in a macro. Because it is a macro, I
cannot reference a certain date (Dates change but the macro won't). How can
I write this, any help would be appreciated.

Could you find the maximum (latest) date from the range and then
subtract 3 days from this? Allocate the result to a variable and use
this as the filter value (Custom, greater than or equal to) etc.

Hope this helps.

Pete

On Sep 21, 8:20 pm, mulehead
wrote:
I am trying to filter on the last three days of a running report (dates
always changing in a twenty day period) in a macro. Because it is a macro, I
cannot reference a certain date (Dates change but the macro won't). How can
I write this, any help would be appreciated.

I've just noticed that Fred Smith has given you a similar reply
earlier in your other thread - why start a new thread?

Pete

On Sep 22, 1:04 am, Pete_UK wrote:
Could you find the maximum (latest) date from the range and then
subtract 3 days from this? Allocate the result to a variable and use
this as the filter value (Custom, greater than or equal to) etc.

Hope this helps.

Pete

On Sep 21, 8:20 pm, mulehead
wrote:



I am trying to filter on the last three days of a running report (dates
always changing in a twenty day period) in a macro. Because it is a macro, I
cannot reference a certain date (Dates change but the macro won't). How can
I write this, any help would be appreciated.- Hide quoted text -

- Show quoted text -