Sorry - please let me explain this better
I want to set a Creation date for the record and sort by this. Then I want to set a
modification date and make the cancellation date = modification date + an expiry
period (probably 30 days)
I think I can search for dates greater than the current date in a regular Search
action (I thought date searches like this didn't work - but they seem to) but I want
to work with calculated dates so I don't have to store calculated dates in Filemaker
So, I want to find dates where:
(modification date + <@ARG EXPIRYDURATION>) >= current date
- and only modification date and creation date are held in the database...
Original post:
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
