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
FormatStringproperty of that field todd/MM/yyyyAlso you need to set the
InputMaskproperty to00/00/0000