Jump to content

Find using date dependant upon radio button value


BooJigga
 Share

This topic is 6529 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

*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

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

This topic is 6529 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.