AnsweredAssumed Answered

Filtering records

Question asked by jb362 on Oct 7, 2012
Latest reply on Oct 7, 2012 by jb362


Filtering records



     I’m trying to find records which fall within a specified date range and also have a specific Disposition ID

     Script steps…

     Set Variable[$StartDate; Value: Get(CurrentDate)]

     Set Variable[$EndDate; Value: $StartDate + 30]

     Set Variable[$DateRange; Value: $StartDate & “…” & $EndDate]

     Set Variable[$DispositionID; Value: 2]

     Go to Layout [“Appointments with 30 Days” (Appointments)]

     Enter Find Mode []

     Set Error Capture [On]

     Perform Find [Restore]

     The script steps in the screen shot below end up finding every record.

     If I remove either of the Actions from the Find Requests the result is the set specified by that request.

     Obviously my logic is supect but here’s what I think the above Find Requests mean.

     First find the set of records which are within the specified Date Range.

     Then the found set is further filtered to also satisfy the Disposition ID requirement.

     What’s the error in my logic?

     FWIW: I’m a hobbyist and still pretty new to FMP.