I was trying out some constraints on a datagrid and I stumbled upon this:
The last line: Value should be empty, '[%CurrentDateTime%]' seems to suggest it was once upon a time possible.
I know I can use an xpath but I am just curious as to why is it not possible to use a constraint on Date and Time with a database retrieve?
For those interested I added an Idea requesting this possibility: https://forum.mendixcloud.com/link/ideas/918
I think the offline capabilities of Mendix are not yet ready to filter on the Date attribute (and probably it was possible before). So if you don't want to use offline capabilities in your app, just use XPath as datasource for your datagrid. And if you do want to use offline capabilities in your app, I think your screwed. You should definitely send in this as an idea on this forum to get this on the agenda as feature request.