1
Help for ParamQuery Pro / Re: Filter 'Equal' Condition Not Working as Expected in v10.1.0 for datetime columns
« on: February 14, 2025, 11:22:17 pm »
Please add offset in the compare function for now to make the dates comparable.
This compare function assumes that all dates in column are in datetime format while the date entered in filter box is date only. If dates in column are also dates ( without time ), then don't add offset to the val.
https://jsfiddle.net/erpmgxto/3/
Code: [Select]
compare: function (cd, val) {
var offset = new Date(val).getTimezoneOffset() * 60 * 1000
val += offset
if (cd - val >= 0 && cd - val < 24 * 3600 * 1000) {
return true
}
},
This compare function assumes that all dates in column are in datetime format while the date entered in filter box is date only. If dates in column are also dates ( without time ), then don't add offset to the val.
https://jsfiddle.net/erpmgxto/3/