wgraphics
asked on
CR 2011- Create a formula to show data from the previous 2 weeks
Hello
We are using CR 2011 -
I have a date field in a report called Action Due Date.
When the report is ran I would like to see only information pertaining to the last 2 weeks of the Action Due Date.
For example, say the report will be run on Friday, May 24. After it is refreshed, I only need data on the report from May 10-May24.
Any ideas? Thanks for taking the time.
Megan
We are using CR 2011 -
I have a date field in a report called Action Due Date.
When the report is ran I would like to see only information pertaining to the last 2 weeks of the Action Due Date.
For example, say the report will be run on Friday, May 24. After it is refreshed, I only need data on the report from May 10-May24.
Any ideas? Thanks for taking the time.
Megan
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, you're a rock star.