Print Page | Close Window

Display a reports Date Range based on LastFullWeek 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=21294 Printed Date: 06 May 2024 at 4:39pm Topic: Display a reports Date Range based on LastFullWeek Posted By: tdavenport Subject: Display a reports Date Range based on LastFullWeek Date Posted: 23 Jan 2015 at 4:51am I have a report that is filtered on the LastFullWeek function. It works fine. However, I want to display the date range in the report header as a "From and To" date. The function itself only returns True or False. I don't want to use dates from the returned records because some days may be missing (such as Saturday and Sunday). I'd like the display to show Sunday as the starting date and Saturday as the end date (but in date format like this: 1-18-2015 through 1-24-2015) Any ideas? Thank you! ------------- Any and all suggestions are welcome. Replies: Posted By: tdavenport Date Posted: 23 Jan 2015 at 8:27am Duh.. Too simple. I'm still a rookie I guess. Here it is: 1st Function: MINIMUM(LastFullWeek) 2nd Function: MAXIMUM(LastFullWeek) ------------- Any and all suggestions are welcome.

Print Page | Close Window