Greater than no working on Dates
Hello! 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
Accepted Solution
Novacomp
GT
@ShyjuValappil ty I was doing the comparation in the wrong way
Updated: 6 Sep 2021 9:32 EDT
Blue Rose Technologies
DE
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.
Accepted Solution
Novacomp
GT
@ShyjuValappil ty I was doing the comparation in the wrong way