Date Formula (From-To) HELP
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22275
Printed Date: 03 May 2024 at 1:20am
Topic: Date Formula (From-To) HELP
Posted By: Beso90
Subject: Date Formula (From-To) HELP
Date Posted: 28 Mar 2017 at 4:51am
|
Hello,
I'm setting up a report to be generated every week to show on-time deliveries. I have a similar report to show me the on-time deliveries for the previous day. and the formula for that is something like: {ShipDate} = (currentdate-1) my question is what formula do i use to give me data from (7 days ago to currentdate-1) ? 
I don't want to set up a manual parameter because i want the report to be sent automatically from the system as an IQAlert, so i need the parameter to be embedded in the report as a selection formula. |
Replies:
Posted By: DBlank
Date Posted: 28 Mar 2017 at 7:12am
| datediff('d',shipdate,today) in 1 to 7 |