Trouble Excel-like Filtering with GridDateTimeColumn

[Đoàn]

I get a trouble when using Excel-like Filtering with GridDateTimeColumn.
It doesn't worked.
Anyone give me an example about it. 
Many thanks !

[Attila Antal]

Hi Đoàn,

Based on the alert from the screenshot, I assume that RadGrid with Batch Edit mode is used, but I would need more information to be able to help.

It would be very helpful if you could share some more details with us, such as the markup and code behind code of the Grid. This would help me understand how it is configured and allow me to give you an accurate answer.

Kind regards,
Attila Antal
Progress Telerik

[Đoàn]

Hi Admin Attila Antal,

Thanks for reply me,

Short description, I used Mode Like-excel Filtering for my Radgird. But I can not find any properties for date-ranger with Column Data is Datetime 

This is column code

<telerik:GridDateTimeColumn
                         DataField="date_import"
                         HeaderText="Ngày nhập"
                         AutoPostBackOnFilter="true"
                         DataType="System.DateTime"                                                
                         DataFormatString="{0:dd MMMM yyyy}"
                         AllowFiltering="true"  > 


                        <HeaderStyle Width="150px" HorizontalAlign="Center"/> 
                        <ItemStyle Width="150px" HorizontalAlign="Center" />  
                        <FooterStyle Width="150px" /> 
                    </telerik:GridDateTimeColumn> 

[Attila Antal]

Hi Đoàn,

If this is not set in the Markup, most likely it comes from a logic in the code behind. 

Can you try to define the MinDate and MaxDate properties in the Markup like this?

<telerik:GridDateTimeColumn
    DataField="date_import"
    HeaderText="Ngày nhập"
    AutoPostBackOnFilter="true"
    DataType="System.DateTime"
    DataFormatString="{0:dd MMMM yyyy}"
    AllowFiltering="true"
    MinDate="01/01/1900"
    MaxDate="12/31/2050">

    <HeaderStyle Width="150px" HorizontalAlign="Center" />
    <ItemStyle Width="150px" HorizontalAlign="Center" />
    <FooterStyle Width="150px" />
</telerik:GridDateTimeColumn>

 

If that does not fix the issue, most probably some code in the server side is changing that and it sets the MinDate to be later than the MaxDate, hence the error.

Would you mind sharing the entire RadGrid markup and code behind code that is handling it?

 

Kind regards,
Attila Antal
Progress Telerik

[Đoàn]

Hi Attila Antal,

I follow your guide but it still not work. 

[Attila Antal]

Hi Đoàn,

I am only guessing what could be the problem as I cannot see the current setup. That is why I asked for the RadGrid markup and code behind code.

In order to be able to help, please share those details with me.

Kind regards,
Attila Antal
Progress Telerik