Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Date Forumla Crystal XI

Posted on 2009-02-24
Medium Priority
Last Modified: 2012-06-27
Hi -
I want to create a formula in Crystal XI that counts ten days back from the current date.
Thanks, Stacy
Question by:stacydr
LVL 10

Accepted Solution

dougvarga earned 1000 total points
ID: 23722748
To just make a formula that displays the date 10 days ago, you'd so something like:

But I imagine by "count back" you mean selects records that are 10 days back?

If so, try this as a record selection formula (you'll have to choose the field from your DB that has the date you're trying to compare to):

{mydatabase.mydatefield} = DateAdd("d",-10,CurrentDate)

If you were looking to select all records with activity in the past 10 days, you might try something like:

{mydatabase.mydatefield} >= DateAdd("d",-10,CurrentDate)

Hope this points you in the right direction.

Author Closing Comment

ID: 31550611
thanks so much -- you were absolutely right -- the third formula was the one I was looking for!! thanks...Stacy

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

577 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