Hello,
I've been struggling with issue, how to get EnableTimeIndependentFiltering property working in GridTemplateColumn.
Let me describe the issue. We have datetime columns in our SQL database. These columns have in some rows normal dates such 21.9.2017 15:10:00 but some have the intial value 01.01.1900 00:00:00. Because I don't know how to suppress this initial value to be shown, I use GridTemplateColumn instead of GridDateTimeColumn. The problem is that this column even with property DataType="System.DateTime" didn't know EnableTimeIndependentFiltering.
Here is my sample column declaration:
<
telerik:GridTemplateColumn
DataField
=
"TransferOrder_ChangedDate"
HeaderText
=
"Dátum vykonania"
HeaderStyle-Font-Bold
=
"true"
HeaderStyle-HorizontalAlign
=
"Center"
ReadOnly
=
"True"
SortExpression
=
"TransferOrder_ChangedDate"
DataType
=
"System.DateTime"
ItemStyle-HorizontalAlign
=
"Left"
UniqueName
=
"TransferOrder_ChangedDate"
FilterControlWidth
=
"120px"
ColumnGroupName
=
"TransferOrder"
AutoPostBackOnFilter
=
"false"
CurrentFilterFunction
=
"EqualTo"
>
<
ItemTemplate
>
<
asp:Label
ID
=
"lbl_TransferOrder_ChangedDate"
runat
=
"server"
Text='<%# ((DataRowView)Container.DataItem)["TransferOrder_ChangedDate"].ToString() == nulldateTime.ToString() ? " ": string.Format("{0:dd.MM.yyyy HH:mm:ss}", ((DataRowView)Container.DataItem)["TransferOrder_ChangedDate"]) %>'></
asp:Label
>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
The question is how can I filter data based on whole day value without need to type hours, minutes and second in GridTemplateColumn ?
Thank you
Best regards
Vasssek