[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Crystal Report LASTFullweek

Posted on 2014-08-05
1
Medium Priority
?
502 Views
Last Modified: 2014-08-08
I submitted a question regarding this issue before.  If I use the LASTFUllWeek in this formula

 "From " + cstr(minimum(LastFullWeek), "MM/dd/yyyy") +
          " to " + cstr(maximum(LastFullWeek), "MM/dd/yyyy")

 It does show the last 7 days; however, I want to put in a {?StartDate}.  From that {?StartDate} obtain the data minimum and maximum days selected.  I only want to use one {?startDate} prompt to obtain the "From" + "To" --- Can this be done in this formula?
0
Comment
Question by:cdmccoy
1 Comment
 
LVL 101

Accepted Solution

by:
mlmcc earned 1420 total points
ID: 40241444
Sure.
FirstDayofWeek
DateAdd("D",-DayofWeek({?StartDate}),({?StartDate}) + 1

LastDayofWeek
DateAdd("D",-DayofWeek({?StartDate}),({?StartDate}) + 7



In the Selection

{@FirstDayofWeek} <= {Datefield}  AND {@LastDayofWeek} >= {Datefield}

mlmcc
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Screencast - Getting to Know the Pipeline
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question