[Progress Communities] [Progress OpenEdge ABL] Forum Post: Kendo grid with column filtering on a DATE field (not DATETIME)

[wes.rector]

We have lots of DATE fields in our tables going way back to before there was a DATETIME type. We've noticed that if we enable Column Filtering on a grid and try to filter on one of those DATE fields we get the good old datatype mismatch error: ** Incompatible data types in expression or assignment. (223) Failed to auto-prepare an automatic fill query. (11981) The ablFilter that gets built looks like this: entry-date = DATETIME(10, 13, 2004, 00, 00, 00, 000) Of course, entry-date is a DATE field, not DATETIME, so boom goes the dynamite. How can we best change this behavior so that ablFilter gets DATE(10, 13, 2004) instead of DATETIME(10, 13, 2004, 00, 00, 00, 000) ?

Continue reading...