I have a janus
grid, which one of its columns is of type DateTime
.Since I only show the date part of column data in the grid, I want to filter the column by date too. But in filter editor I have to write whole Datetime
that is not desirable. What should I do to ignore the time part of the data in filtering the column? I set the CompareTarget
to Text
but it doesn't work for greater, less than or equal operation for time
if (columnInfo.ColumnType == DateTime)
{
column.CompareTarget = ColumnCompareTarget.Text;
}
You need to set the
FormatString
property of that field todd/MM/yyyy
Also you need to set the
InputMask
property to00/00/0000