Solved

CR 2011- Create a formula to show data from the previous 2 weeks

Posted on 2013-05-14
2
267 Views
Last Modified: 2013-05-14
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
Comment
Question by:wgraphics
2 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 39166513
Try this

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

ANother way

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

mlmcc
0
 

Author Closing Comment

by:wgraphics
ID: 39166535
You always come through for me, mlmcc.
Thanks, you're a rock star.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This video discusses moving either the default database or any database to a new volume.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now