AnsweredAssumed Answered

How do you search on a date field that is not empty?

Question asked by disabled_britishlabs on Feb 15, 2018
Latest reply on Feb 15, 2018 by beverly

I moved from a Bento database to a Filemaker Database for my small business. In Bento I was able to use create Smart Collection to display records which matched any or all conditions I chose. For example I displayed my reservation lists of clients by displaying records whose "reservation date" field was not empty.  I see conditions such as =, <, >, etc but do not see "is not empty" as an option when searching records in Filemaker. I want to create a report listing those client contacts who have made deposits which is indicated by date field which is not empty.

Outcomes