Filter Date Code for macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
I've just noticed that Fred Smith has given you a similar reply
earlier in your other thread - why start a new thread?

Pete
 
Back
Top