Datagrid Datetime Filter Doesnt Work For Smaller or equal Setting

1
Hello All, I have added a datetime filter on data grid with comparison setting as ‘smaller or equal’. But when I try to use this, it does not consider the time part of the date and returns incorrect values. However if I am using ‘greater or equal’ setting then it works totally fine.   In the attached screenshot I have set the filter value as Book-in time <= ‘11-12-2020 13:00:00’, it should only show 2 records but instead it is showing all the records for that day. Is this a bug on the datetime filter?
asked
1 answers
0

Seems to be a bug IMHO.

Created an entity with a date time (localized) attribute. Timezone in the setting is None.

Added the attribute in a search field with the option smaller or equal on a datagrid.

Entered 2 values: 24/12/2020 12:00 and 24/12/2020 10:00

When searching on 23/12/2020 11:00 this should yield no results as both entries have a date time after the datetime being search for in the smaller or equal field. This however yields 1 record: 24/12/2020 10:00

Changing the input for the search to 23/12/2020 13:00 returns both records.

Searching on 24/12/2020 11:00 will return both records as well, this should only retrun the record at 10:00.

Searching on 22/12/2020 11:00 will retrun no results as expected and when using the 25th as date will return both records as expected as well.

Changing the server timezone to GMT+01:00 has the same effect as desribed above

Suggest to file a ticket with Mendix support as this comparison function seems to be a bit buggy.

 

answered