Print Page | Close Window

Date Range

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Announcements
Forum Discription: Please check this section for the latest announcements from Crystal Reports Forum
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15786
Printed Date: 02 May 2025 at 8:06am


Topic: Date Range
Posted By: Alexander
Subject: Date Range
Date Posted: 03 Mar 2012 at 6:36pm
Dear All,
I want to run a report where i just have to refresh the report & automatically it should show the records for last three days only from the current date.
 
Can anyone help me on this?
 
Regards
Alex


Replies:
Posted By: hilfy
Date Posted: 04 Mar 2012 at 4:46pm
You'll use a formula in the selection criteria instead of one of the options from the Select Expert but you have to go to the Select Expert to start.  If you don't have anything set up in here already, select a field - doesn't matter what it is.
 
Click on the Formula button and add something like the following to the the formula:
 
{table.DateField} >= (CurrentDate - 3) and {table.DateField) < CurrentDate
 
NOTE:  This assumes you don't want the current date.  If you do, change the "<" to "<=".
 
-Dell
 
 


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window