Question


CBA
AU
Last activity: 12 May 2022 20:43 EDT
date range in report definition filter
Hi team,
I need to fetch report using date range in filter. How can I give from and to range single filter condition. Please advise in 7.3.1
exp: ABC case details from 01 july 2021 to 31 march 2022.


Coforge DPA
GB
@Sam27 Is this report in report browser or any where else? And are you expecting the user to enter the from and to dates?
Regards
Bhavya


CBA
AU
@Bhavya Thanks for the reply. Nope, I need to extract the report in RD for business analysis


Pegasystems Inc.
US
@Sam27 - I don't know what's the real value you are getting in setting the date range in the single filter condition. However, if you don't have the exact dates then, in the single filter condition, you can click on the "Select values" button and use something like "Last n days" (where n can be the number of days back you want to go) OR "Current Quarter", "Previous Quarter" etc.
e.g. <CaseDate> is equal Last n days
If you have exact dates then, I would suggest using something like below:
<CaseDate> is greater than or equal Param.FromDate
AND
<CaseDate> is less than or equal Param.ToDate
Thanks
Sachin


CBA
AU
@gupts3 thanks for the reply. Sorry I did get your reponse
I have to fetch case ABC details from date range 01 july 2021 to 31 march 2022. How to achieve it in rd
Please advise.


Pegasystems Inc.
US


CBA
AU
@gupts3 thanks, I performed already in same way,
Would you mind sharing screenshot for the param approach please for the mentioned dates


Pegasystems Inc.
US
@Sam27 I guess this is what you looking for. See attached screenshots...


CBA
AU
@gupts3 Thankyou for the response


Broadridge Financial Solutions (India) Private Ltd
IN
@Sam27 Create a report definition with ABC case detail. Use filter condition with two input parameters "From Date" and "To Date"


CBA
AU
@SuryaBasani Thanks for the reply --- i tried solution given by you but its throwing error :( .
Could you please help me on this.


Areteans
IN
Configure the filter conditions as @SuryaBasani suggested and Add those 2 params in parameters tab.
Updated: 9 May 2022 19:45 EDT


CBA
AU
@HariPriyaY I am getting this error


CBA
AU
@HariPriyaY Can you please reply on this


CBA
AU
@SuryaBasani -- Can you please reply


Broadridge Financial Solutions (India) Private Ltd
IN
@Sam27 First configure the filter conditions as attached below attachment. Then You can run the report from Actions+Run and the report will execute and It will display like attachment2.
Once you click on the filters it will populates a pop up like attachment3.
Then you can pass the input dates into that filters.
Thank you,
Surya


CBA
AU
@SuryaBasani Many thanks for the response.
I tried = as suggested but the filter date will give only 2 dates
date=23/05/2021 and 23/03/2022
Actual requirement is for duration/period 23/05/2021 to 23/03/2022
Accepted Solution
Updated: 12 May 2022 20:40 EDT


Broadridge Financial Solutions (India) Private Ltd
IN
Please pass the two input values and please make sure use right filter relationship.
Updated: 12 May 2022 20:43 EDT


CBA
AU
@SuryaBasani many thanks surya-- for sharing your knowledge and looking into this question :)