problem with eom()

Kenneth Brody kenbrody at spamcop.net
Wed Oct 29 07:40:43 PDT 2014


On 10/28/2014 11:08 PM, Bruce Easton wrote:
> Testing under both Linux 5.7.4.07 and 5.0.14 shows the behavior and
> requirement for the eom() function that Ken specifies.   However, IMHO,
> considering the history of differing requirements for functions over the
> years regarding expressions versus fields, it not very helpful that both the
> online manual and the screen help for eom() describe the parameter syntax
> requirement as "date_expr" or "date expression".  I'm sure clerk is more
> efficient with such strictness for functions, but the documentation should
> be clearer.  And maybe for at least the screen help, it now is. An early
> Windows filepro 5.7 still references "expression", but for the screen help
> for the 5.7.4.07, it has been updated.  In the new screen help for the date
> functions the parameters are referenced as "d" or "dd", and although I don't
> see a specific reference that the parameter be a cast field of some sort,
> there are examples now that conform to such a requirement.
[...]

Point taken.  Note, however, that:

     foobar(12) { "/01/" { foobar(13)

is not a "date expression".  It's an expression that returns a simple string 
which happens to "look like" a date.  And, in the specific example in the 
OP, it could be either "MDYY/" or "DMYY/".  It's not possible, in the 
general sense, for filePro to "know" what type of date you want it to be 
interpreted as.

If the help files don't explicitly state that passing a "non-date 
expression" will return the end of the current month, then it should be updated.

-- 
Kenneth Brody


More information about the Filepro-list mailing list