problem with filter grid by between date

[Jose Arturo]

Hello, I try filter by between date, but not working. There show me a data 21/07/2021 to 16/09/2021.
I try filter this range 01/08/2021 to 31/08/2021 but on the gris show me this list  01/08/2021 to 30/08/2021. the 31/08/2021 not show me. example:

Not filter	Filter 01/08/2021 to 31/08/2021
28/07/2021 01/08/2021 01/08/2021 05/08/2021 06/08/2021 15/08/2021 22/08/2021 30/08/2021 30/08/2021 31/08/2021 31/08/2021 01/09/2021 05/09/2021	01/08/2021 01/08/2021 05/08/2021 06/08/2021 15/08/2021 22/08/2021 30/08/2021 30/08/2021 What happen with 31/08/2021 ??

Also I try with command and not comand it is same problem.

 { field: "OrderDate", operator: "greaterthanorequal", predicate: "and", matchcase: true , value: startOfFilter },
 { field: "OrderDate", operator: "lessthanorequal", predicate: "and", matchcase: true , value: endOfFilter }
or
{ field: "OrderDate", operator: "lessthan", predicate: "and", matchcase: true , value: endOfFilter }

[Sujith Kumar Rajkumar]

Hi Jose, 

 

Greetings from Syncfusion support. 

 

We checked the reported problem with similar date values but unfortunately were unable to reproduce it from our end as the between date filter was working properly with excel filter. Please check the below sample for reference, 

 

Sample: https://www.syncfusion.com/downloads/support/forum/168936/ze/GridWithExcelFilter-241842142 

 

We suspect that you have time value along with the date and only trying to filter based on the date value. If so, the time value in the filtered date might not have matched thus causing the ‘31/08/21’ value to not be displayed. 

 

So please ensure this case from your end and if problem still persists then please share us the following information to validate further on this, 

 

• Share us the date value for ‘31/08/21’ bound in the Grid data source.
• Share us the Grid code file.
• Let us know how you have referenced the script file for the EJ2 controls in your application.
• If possible share us a simple sample to replicate the problem or try reproducing it in the above provided sample.

 

Regards, 

Sujith R 

[Jose Arturo]

Hello. I find an example.

http://jsplayground.syncfusion.com/chdhdbrb

If you see there, the filter is day 13 to day 14, there show day 13 not all 14.

On my project show me this. look the images.

Whit filters


there exist the 31/08/2021

Also I create a button, but is same result

  var gridObj = $("#Grid").ejGrid("instance");

                gridObj.model.filterSettings.filteredColumns = [

                    { field: "u.DeliveryDate", operator: "greaterthanorequal", predicate: "and", matchcase: true, value: startOfFilter },

                    { field: "u.DeliveryDate", operator: "lessthanorequal", predicate: "and", matchcase: true, value: endOfFilter }];

                gridObj.refreshContent();

[Pon Selva Jeganathan]

Hi Jose,  

   

Thanks for the update. 

  

Query: problem with filter grid by between date

  

We checked your query by preparing sample based on your code snippet, but We are unable to reproduce the issue at our end.  

  

Please refer to the below sample, 

https://www.syncfusion.com/downloads/support/forum/169041/ze/WebApplication1_-_EJ1_MVC-1348558601 

  

Please refer to the below video demo. 

https://www.syncfusion.com/downloads/support/forum/169041/ze/Filter_issue1587029323 

  

After following the above reference, still faced issue please share us the following details.

  

1. Share the product detail version.
2. Share the Tree Grid rendering code example.
3. Share the screenshot of stacktrace details(face if any)
4. If possible, reproduce the issue in the attached sample or share the issue reproducible sample.
5. Share the video demo of the issue.

  

The provided information will be helpful to provide you response as early as possible.   

  

Query: If you see there, the filter is day 13 to day 14, there show day 13 not all 14. 

  

Sample: http://jsplayground.syncfusion.com/chdhdbrb 

  

We examined the above sample, and we discovered that day 14 has a different time value (like that 01:00:00,02:00:00). So, not all of the day 14 values are displayed. 

  

Kindly get back to us for further assistance. 

  

Regards, 

Pon selva