Find using date dependant upon radio button value

[BooJigga]

*Disclaimer* Please forgive the newbness of this post.

Developing a database (first time Filemaker user) and I need to perform a find based on "Date Received".

Basically, I have 4 reports that are due 15, 30, 45, and 60 days _after_ date received. I need to script a find that will search through the files and display the records that are within the < 15, < 30, etc. time frame.

To make it a bit easier I'm probably going to create 4 layouts for each search, but am having a problem figuring out the calculation. Also, I do not want to show records that have been "closed".. This field is a radio button.

Sorry if this is confusing... Any thoughts?

Version: v6.x

Platform: Windows XP

[CyborgSam]

Here's a way to do this for 15 days. You can use one layout and change the script step for 15, 30, 45 & 60, perhaps with an If Test. Make sure the layout has the fields used in the script steps below.

I assume that RecordClosed=1 means the record is closed.

Set Field ["g.Date2Check", "Status(CurrentDate) - 15"]

Enter Find Mode []

Insert Calculated Result ["DateReceived", ""<=" & DateToText(Status(CurrentDate) - 15)"]

Set Field ["RecordClosed", "0"]

Perform Find [Replace Found Set]

Is this what you wanted?