Hello! I seem to be having a problem applying a standard filter to a column that has dates inside of it. When I’m setting the conditions inside the standard filter, it only gives me results when I use certain conditions. For example, If I try to use the, “>, <, <=, =>,” or any other such conditions, the spreadsheet doesn’t show any data after the filter is applied. But if I use the condition “=,” the spreadsheet shows results. What I’m trying to do is get the column to only display data “<=” 11/3/2020. I assume my issue is caused by user error so any education you can offer would be appreciated.
Attached is a sample file of the column I’m working with.
Question #2 Example.ods (16.9 KB)