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.
@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
@Bhavya Thanks for the reply. Nope, I need to extract the report in RD for business analysis
@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. is equal Last n days
If you have exact dates then, I would suggest using something like below:
is greater than or equal Param.FromDate
AND
is less than or equal Param.ToDate
Thanks
Sachin
@Sam27 if you are not getting From and To date as param then, you can do as per the screenshot:
@Sam27 Create a report definition with ABC case detail. Use filter condition with two input parameters “From Date” and “To Date”
@SuryaBasani Thanks for the reply — i tried solution given by you but its throwing error 
.
Could you please help me on this.
@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
Last n days works only for specific days, specified i tried for 30 days like below and it worked, when tried with last 5 days, 10 days it does not works, but thanks for your inputs it helped.
@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.
Configure the filter conditions as @SuryaBasani suggested and Add those 2 params in parameters tab.
@SuryaBasani – Can you please reply
@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
To All,
We need to pass parameters to Report Definition.
pxUpdateDateTime>Param.UpdateDateTime.
Where Param.UpdateDateTime is current date time - 90 Days.
How to write expression for -90 days?
@gupts3 thanks, I performed already in same way,
Would you mind sharing screenshot for the param approach please for the mentioned dates
@gupts3 Thankyou for the response
@HariPriyaY Can you please reply on this