Date Filter Filter.Type.Menu - Filter between 2 dates

[Megatron]

Hello, how can we get the date filter to filter between 2 dates.

On the help page it only showsless than, greater than etc,
Can you tell me how to enable filtering between 2 dates.

thanks

[Jayaprakash Kamaraj]

Hi Megatron, 

Thank you for contacting Syncfusion support. 

To overcome this problem we suggest you to use excel filtering. You can enable excel menu by setting FilterType as Excel in FilterSettings . The excel menu contains an option such as Sorting, Clear filter, submenu for advanced filtering. In this filtering we have between options in excel filter dialog. Please refer to the below help document, code example and sample. 

https://help.syncfusion.com/aspnetmvc/grid/filtering#excel-like-filter 

@(Html.EJ().Grid<object>("Grid") 

     .Datasource((IEnumerable<object>)ViewBag.datasource) 

    .AllowPaging() 

    .AllowFiltering() 

    .FilterSettings(fil=>fil.FilterType(FilterType.Excel)) 

              … 

 

            

        })) 

Online demo Sample:  https://mvc.syncfusion.com/demos/web/grid/filteringmenu 

 

Regards, 

Jayaprakash K.