I have a database, and one of the fields contains dates. I have a form. On the form, is a text display object. I want the text display object to show me the total number of records that do not have an empty date field. Either a formula or a procedure within the definition of the text display object should give me what I want, but all I get are syntax errors or a blank result.
???
Replacing {«MyDateField»>0} with either {not emptycell(MyDateField»)}, or {not(emptycell(MyDateField»))}
should work and could be generalized to count records with non-date fields that aren’t empty. Emptycell( is the, new to Panorama X, function provided to specifically check for empty data cells.