Confront dates on Web Designer

Hello everyone,

I created a new container and an alert as extensions in the module VI_ObjectEdit_Person of the Web Designer. I'm using the viewing condition because I want the alert to show only when the ExitDate of the Person is set.

The employees I'm working with, if not externals, have the ExitDate set to "2999-01-01  23:59", to represent that they don't have any ExitDate.

So I've tried writing the viewing condition of the container as from EditTable select current ExitDate < '2999-01-01'. With this condition I see a behavior I don't understand: the alert is shown on the 30th or 31st of each month in the past and in the future.

What am I missing?

Thank you,

Lucrezia