This is a migrated thread and some comments may be shown as answers.

DateTime filtering date only with custom format

11 Answers 891 Views

GridView

This is a migrated thread and some comments may be shown as answers.

Thomas asked on 08 Jan 2016, 10:09 AM

Hi,

I have DateTime columns in my gridview.
I will see the full date and time values with a custom format string yyyy-MM-dd HH:mm:ss.

But I only want to filter for the date only, so I set the FilterMemberPath to the date value.

<telerik:GridViewDataColumn Header="Start-Date"
                            IsCustomSortingEnabled="False"
                            DataMemberBinding="{Binding StartTime}"
                            FilterMemberPath="StartTime.Value.Date"
                            DataFormatString="{} {0:yyyy-MM-dd HH:mm:ss}" />

I'm now able to filter for a specific date with equal to,

but in the selection list of containing entries the dates will be displayed with 12:00:00 AM time :-(

How could I change the format of the filter string to yyyy-MM-dd?

Many thanks for all help.

Cheers,

Thomas

11 Answers, 1 is accepted

answered on 13 Jan 2016, 08:52 AM

Hi Thomas,

Indeed, the default behavior of the Filtering control is to add a value for hours, minutes and seconds of the bound DateTime property. Unfortunately, there is no straightforward approach for achieving the desired behavior.

An approach you could take is to work with the filtering events of the RadGridView and change the DataFormatString property. You can subscribe for the FilterOperatorsLoading event, which is fired every time the filtering control is opened. Eventually, use the Filtered event to switch the FormatString to the original one. This, however, would work only if some filtering has been applied and could be used in specific scenarios.

Regards,
Stefan Nenchev
Telerik

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items

answered on 13 Jan 2016, 02:42 PM

RadGridView-WPF-NoXAML-115.zip

Hi Thomas,

I have investigated the issue further and managed to come up with a better approach. It includes changing the CellTemplate of the specific column. Please refer to the following code snippet:

<telerik:GridViewDataColumn DataMemberBinding="{Binding Established.Date}"

Header="Est."

DataFormatString="{}{0:yyyy-MM-dd}">

<telerik:GridViewDataColumn.CellTemplate>

<DataTemplate>

<TextBlock Text="{Binding Established, StringFormat={}{0:yyyy-MM-dd hh:mm:ss}}"/>

</DataTemplate>

</telerik:GridViewDataColumn.CellTemplate>

</telerik:GridViewDataColumn>

I have also attached a sample project implementing the suggested approach.

Regards,
Stefan Nenchev
Telerik

answered on 14 Jan 2016, 02:01 PM

Hi Thomas,

You need to change the CurrentCulture of your application. The RadDateTimePicker uses that Culture in order to parse the input date and time.

Please try the following approach:

InitializeComponent();

var culture = new CultureInfo("en-US");

var dtfInfo = new DateTimeFormatInfo

{

ShortDatePattern = "yyyy-MM-dd",

ShortTimePattern = "HH:mm",

DateSeparator = "-"

};

culture.DateTimeFormat = dtfInfo;

Thread.CurrentThread.CurrentCulture = culture;

Thread.CurrentThread.CurrentUICulture = culture;

You can find more information at the following article from our documentation page - How to Set Different Culture.

I have tested this approach and it seems to do the job. Please update me if everything is working as expected at your end as well.

Regards,
Stefan Nenchev
Telerik

answered on 19 Jan 2016, 02:59 PM

RadGridView-WPF-AR-15.zip

Hello Thomas,

In the video recorded I have set a nullable DateTime property and I am able to perform the sorting. I have attached the sample project once again so you can review it. Would it be possible for you to update this project so that it represents your setup? Eventually, you can create a ticket and send it over so I can have a more detailed look.

Regards,
Stefan Nenchev
Telerik