I have an RD that filters ".CarID" from a Data page, I want to filter by two dates ".StartDate" and ".EndDate", so I use "Greater than or equal" and "Less than or equal" respectively to compare whit my parameters but I just get the equal part does not calculate if the date is before or after just if is equal I append captures!
Data in data page
My report definition
Runing whit the exact date:
And runing whit a date in range but is not working
***Edited by Moderator: Pooja Gadige to add platform capability tag***
If I understood correct from your screenshot, it is working as expected.
1. In the first filter condition you were trying to get records where Start Date is greater than or equal to 09/03/2021 and End Date is less than or equal to 09/30/2021. Its an AND condition and there is a record matching with this filter.
2. In the second screenshot, filter condition is to get records where Start Date is greater than or equal to 09/03/2021 and End Date is less than or equal to 09/15/2021. We don't have any recors matching this criteria. In the first record even though start date is greater than or equal to 09/03/2021 end date (9/30/2021) is not less than or equal to 09/15/2021.