I have a file that contains a coded field for identity of an event (in the case I have, I need to distinguish between the code PCN, and other codes that may be PCN1, PCN2, etc.) The records also contain a Date of Event field.

I want to find the records that exactly =PCN, and that have occurred in the past 6 months.

I created three calculated fields each specified to return a text result:

(1) Six Month Today, defined as DateToText(Status(CurrentDate))

(2) Six Month Date, defined as DateToText(Status(CurrentDate)-182) and

(3) Six Month Range, defined as Six Month Date &"..." & SIx Month Today

The third field then returns (for today

You can do it without all those intermediary fields, and you need a double equals sign to make the exact match work. Try:

Enter Find Mode []

Set Field [Event ID, "==PCN"]

Insert Calculated Result [Date of Event, DateToText(Status(CurrentDate)-182) & "..." & DateToText(Status(CurrentDate))]

Perform Find []

Works perfectly - I had to convert the files to FMP5 to get the Insert script command, but I intended to do that eventually anyway.

Thanks a lot Russ!

Best Regards,

[color:"blue"] I had to convert the files to FMP5 to get the Insert script command,

It was called Paste Results in earlier versions.

Lee

Thanks, Lee - you may have just saved my charity some money.

Regards,

John

Hi John,

You're Welcome, and I hope it does save you (your charity) some money.

This is not to say that there isn't some benefits to upgrading. I think I'd wait for Version 7 Now though.

Lee