DateTime filter not working

2 posts, 0 answers
  1. Chris
    Chris avatar
    13 posts
    Member since:
    Dec 2011

    Posted 09 Aug 2017 Link to this post

    Hello,

    I'm having troubles getting dates to filter properly using a grid with a telerik:GridDateTimeColumn column.  The column is bound to a datetimeoffset(7) field in sql server, and regardless of what I enter it never seems to return anything in the filter.  Is this due to it being bound to a datetimeoffset rather than datetime or datetime2?  Is this supported by radgrid and If not is there a way to get filtering to work properly?

    Thanks

  2. Eyup
    Admin
    Eyup avatar
    3824 posts

    Posted 14 Aug 2017 Link to this post

    Hi Chris,

    The column should contain proper DateTime values for filtering, sorting, grouping, etc. actions to work properly. The other option is to use them like string values:
    http://www.telerik.com/forums/sort-the-date-column-in-radgrid-on-clicking-of-the-header#p97N_vOtQECB47_EGveuNA

    Regards,
    Eyup
    Progress Telerik
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top