Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 279
  • Last Modified:

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
0
wgraphics
Asked:
wgraphics
1 Solution
 
mlmccCommented:
Try this

{ActionDueDate} IN [(CurrentDate - 14) to (CurrentDate)]

ANother way

{ActionDueDate}  >= CurrentDate - 14  AND {ActionDueDate} <= CurrentDate

mlmcc
0
 
wgraphicsAuthor Commented:
You always come through for me, mlmcc.
Thanks, you're a rock star.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now