OK, something I've struggled with in the past, and resorted to an unstored calculation
in Filemaker plus a look-up. Filemaker experts will recognise the problem..
How do I search for items in a database where a certain date has not been passed? In
other words, I want to find every item where
cancellation date >= current date
I've tried putting code in a Search Builder as a Custom Column, like this:
<@DATEDIFF DATE1='layout_0.CancellationDate' DATE2='<@CURRENTDATE>'> > 0
and also
<@DATEDIFF DATE1='<@COLUMN "layout_0.CancellationDate">' DATE2='<@CURRENTDATE>'>
> 0
- with the last > as the operator and the zero as the value. The operator may need to
be > or < - I don't know if I have it the right way round, but it's not the cause of
the problem
Both these fail, one with the error "-11 Invalid or empty array name. resultSet"
What am I doing wrong, and is this possible? Please bear in mind I'm using Filemaker
Pro and Tango 3.6x and the date (CancellationDate) is held as a standard date in a
date field
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
