Solved

getting data for the last 30 days

Posted on 2012-03-22
1
375 Views
Last Modified: 2012-03-23
I need to add a formula on my report that retrieves data only for the last 30 days basing the current date as the starting point.

Can someone please show me how this can be achieved?

Thank you much.
0
Comment
Question by:metropia
1 Comment
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 37754834
Try something like

{YourDateField} >= CurrentDate - 30

If there are future dates in the field

{YourDateField} >= CurrentDate - 30
AND
{YourDateField} <= CurrentDate


mlmcc
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Display group header even if no detail records 9 63
Converting int to currency 5 31
Crystal Reports remove alpha characters only 5 46
Select Cross-tab total 2 54
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. …
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 …
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

930 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

13 Experts available now in Live!

Get 1:1 Help Now