Filter DateTime Format

[andrea nava]

Hi,

I have two questions incident to Filter in a Gridview

1 I have a column bound to a Date Time property with a format like 'dd/mm/yyyy' . Applying a filter writing in the text area, the date that i have write is translated in a format like 'dd/mm/yyyy hh.mm.ss'. Can I avoid this translation?
2 Can I set the filter window' s height and weight? When i click the filter icon and the window filter is opened its height or weight is out of the allow area.

Thanks.

[andrea nava]

Hi,

Can I have an answer please? This is of primary importance for my project..

thanks..

[Rossen Hristov]

Hello andrea nava,

This translation cannot be avoided, because the moment that you enter a string in the text-box it is parsed and converted to a DateTime object. After that the ToString representation of this DateTime object becomes the text of the TextBox. Unfortunately, .NET string formatting is a one way process and once a value was formatted, the reverse operation cannot be carried out, because it is indeterminate.

What you can do is create a your very own custom filtering control like described in this and this blog posts.

Here is an online example of a custom filtering control designed specifically for DateTime columns. Look at the "Founded" column. Its filter displays two RadDatePickers which are designed for handling DateTime values better than a simple TextBox.

You can take the custom filtering control from the example and use it for your project. You can extend it as well. This will also allow you to control the size of the filtering control, since it will be your own.

I hope this helps.

Greetings,
Ross
the Telerik team

[andrea nava]

Thanks for your help.

Last question: is there the substantial possibility that you implement a DateTime Column with its DateTime Filter in the next release?

thank you very mutch.

Andrea Nava

[Rossen Hristov]

Hi andrea nava,

It will definitely not make it on time for the Q2 release, but we hope we will provide it for the Q3 one. Excuse us for the inconvenience.

Sincerely yours,
Ross
the Telerik team

[Rossen Hristov]

Hi andrea nava,

You can vote for this feature through its PITS Issue ID: 2664

Sincerely yours,
Ross
the Telerik team