🚀 go-pugleaf

charlesa@niwot.scd.ucar.edu (Charles Albrecht) writes:
>The function you've probably written is:  Today - FromDate
>                                          ^^^^^ (Today is a FMPro function)
>If you define this as a number, FM Pro will beep at you and give you 
>a stern warning that the function will return a value of type "date."  If
>you indicate that you do want to define it as a number, FileMaker will
>gladly allow you to do it, and should give you what you're looking for.

I'll be darned, you are right.  I took the stern warning too
seriously, and didn't attempt to use the number result.  Charles,
thanks for the help!  Thanks also to Brian Schipper, who suggested the
same solution.

Ok, here's another question:  I want to be able to create a field
that adds values from two other fields.  If field "A" contains the
value 20, and field "B" contains 17, I want my proposed field to
become 37.  So far, this is trivial, but I would like this same field
to be selectable for manual data entry if both fields "A" and "B" are
undefined.  If this is not possible, I will settle for having the
field be selectable for data entry without depending on the values in
fields "A" and "B".  Is this possible, or am I asking too much?  I've
looked through the manual for help with this, but haven't found a way
to make it work.

--
-Steven Russell
srussell@uoneuro.uoregon.edu