Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Display a reports Date Range based on LastFullWeek Post Reply Post New Topic
Author Message
tdavenport
Groupie
Groupie
Avatar

Joined: 21 Oct 2008
Location: United States
Online Status: Offline
Posts: 41
Quote tdavenport Replybullet Topic: Display a reports Date Range based on LastFullWeek
    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!

Edited by tdavenport - 23 Jan 2015 at 4:54am
Any and all suggestions are welcome.
IP IP Logged
tdavenport
Groupie
Groupie
Avatar

Joined: 21 Oct 2008
Location: United States
Online Status: Offline
Posts: 41
Quote tdavenport Replybullet 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.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.015 seconds.