GridDateTimeColumn EnableRangeFiltering defaults

[Marco]

I would like to know how to set the defaults of the From and To dates in a GridDateTimeColumn with EnableRangeFiltering="true".

My questions are in particular:

1) how do I set the From and To dates, and which date format should I use when setting them (dd/mm/yyyy, mm/dd/yyyy or yyyy/mm/dd) and which separator (/, - or .)?

2) how do I set the filter to be *between* the From/To dates and don't let the user to change it (not the dates, the type of filter)?

If there is a documentation page where these questions are answered then could you please share the link to it?

[Marco]

I think I figured it out by myself. 

1) First put the following inside the telerik:GridDateTimeColumn tag:

UniqueName="CancelDate" EditDataFormatString="dd.mm.yyyy"

and this in the code behind:

GridColumn date = RadGrid1.MasterTableView.GetColumnSafe("Date");
date.CurrentFilterValue = string.Format("{0} {1}", From.ToShortDateString(), To.ToShortDateString());

2) Put the following inside the telerik:GridDateTimeColumn tag:

ShowFilterIcon="false" CurrentFilterFunction="Between"

[Maria Ilieva]

Hello Marco,

I'm glad that you were able to develop the required functionality on your end. Do let us know if further assistance is needed.

Regards,
Maria Ilieva
Telerik

 

 

[Jaya]

Hi

Admin

Can you solve this 

http://www.telerik.com/forums/how-to-designed-the-aspx-page-and-open-rad-window