GridEx Janus: how to filter column of type DateTime by date

1.8k Views Asked by At

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;
          }
1

There are 1 best solutions below

2
On

You need to set the FormatString property of that field to dd/MM/yyyy

Also you need to set the InputMask property to 00/00/0000