Head scratcher: Query column with a filter –> where (column) is empty. The Query column still returns a record even when the queried filtered column is not empty…anyone able to tell me why?
Pretty sure it’s the lookup of the date. If I switch it to boolean, it works as expected…still a bug!
1 Like
Seems you can sometimes get unexpected behaviour when Big Tables and Date values are combined. I’ve gotten into the habit of using two columns for dates in Big Tables. One that stores the actual date value, and another number type column that stores an integer representation of the date. And then I’ll use that for queries, filters, etc.
1 Like
Yeah…but what’s strange is that I’m just checking to see if the date is/is not empty…it has nothing to do with the value itself.