Bug with dates? (or my error?)

[sumgii]

I have something funky going on with dates. Is this a bug?

The screenshot shows a page listing data from a comments. On the right you will seen that the filter is set to only show where the value of “Creation” is on or after the value of “Comments read” is on the user table.

I have output the value of “Comments read” onto that screenshot. Feb 7th. 18:26:19 . However you can see in the table that it is returning rows from before that time.

It appears that it is only considering the date and not the time. Both columns are set to date and time. I have tried with respect timezones on and with it off.

Looks like a bug to me, but it may well be me missing something important.

[Eric_Penn]

“Is on or after” only takes the date into consideration

Try something like “is after” and it should factor in the time

[sumgii]

[Jeff_Hager]

It’s admittedly confusing. My rule of thumb is that ON can only be true for a split second, so in cases like ‘On or After’, it makes more sense that it only considers the date and not the time. ON can be true for an entire day when only considering the date, while time can only be true for a split second.