My HSQLDB has a pair of date fields that I’d like to use to calculate a duration to display on the input form. The form is based on a query that contains a bunch of fields including one that has a numeric calculation based on two fields. But it appears I can’t do any calculations on date values in the query so I thought I’d do it on the form. The Days() function is what I want to use but so far I haven’t been able to do that. If I put that in a Numerical Field’s Data Value it never displays anything. I’ve been unable to find anything useful on this so far.
Mac OS X 10.14.4