Date format mixed?

[Alexdz]

I am having an issue with the correct date formatting. I am using European which causes the date comparison not working correctly.

I would like to display all items with date before today as shown in the screenshot. On one it’s working and on the other one not. It’s probably an easy fix, but what should I set as the date format to get this working correctly?

[ThinhDinh]

Can you try going into the Data Editor and set a format on the Date column? I think it would honor all the values in that column.

[Alexdz]

yes, that did the trick! thanks once again!!!