Print Page | Close Window

calculation of data based on a specific date Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Report Design Forum Discription: The best way to design a report and problems you have encountered URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22272 Printed Date: 28 Apr 2024 at 5:10pm Topic: calculation of data based on a specific date Posted By: Ytalo Subject: calculation of data based on a specific date Date Posted: 24 Mar 2017 at 7:41am I want to create a formula to automate a report that will show the number of incidents that accord in 7, 14, and 28 days from a specific date (not current date formula)            7days   14days   28days Offense1     2        7        20 Offense2     3        6        19 Replies: Posted By: kevlray Date Posted: 24 Mar 2017 at 9:59am Use the datediff function.  I am assuming that you have some sort of running totals.  You can use the datediff in a formula for the Evaluate section of a running total.

Print Page | Close Window