Hi all,

I'm trying to restrict the data in my report to the past 7 days. Possible?

Views: 35

Reply to This

Replies to This Discussion

figured it out!

added an expression to the container, IF(NOW()-SHIPDATE>6,"N","")

then brought that field into the pivot table and wrote a macro to sort out the "N"'s

add the where in your container statement

i.e.

Where DATEDIFF(day, SHIPDATE, Getdate()) <7

RSS

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

¬© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service