Greater than no working on Dates

General
,
1

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

Data from data page.png
Data from data page.png478×122 3.21 KB

My report definition

Report definition.png
Report definition.png1272×854 59.5 KB
Runing whit the exact date:
Exact date.png
Exact date.png954×365 14 KB

And runing whit a date in range but is not working

Date in range.png
Date in range.png959×417 14.8 KB

2

@LuisA965 please share the SQL query for the reports, It’s help us to debug the issue

3

@LuisA965

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.

4

@ShyjuV69 ty I was doing the comparation in the wrong way