Date Calculation

[Kelly Fisher]

I am sure this is a pretty basic question, but I am still teaching myself filemaker.

This is what I want to do. I need to have a follow-up of records. So if I have a record with the date....10/10/2005 of when something is shipped, and I need to follow up 1 week later, how do I create a script so I can pull up only the records that fit the criteria I am looking for.

Does that make sense?

thanks

[LaRetta]

Hi Kelly,

The simplest way would be to use a Find. You can store your criteria within the Find. "I need to follow up 1 week later." System can schedule it for you. But what if it's a weekend, or you are sick and don't get to it exactly one week later? Usually it works best to search for a date range.

With a Find, you have control. Thinking would be: I want to find all records that shipped 7 through 10 days ago that have a tag field (number field with a 1 in it) saying I need to do something with them. Script would be executed on a layout based upon your orders (or whatever)

Set Error Capture [ On ]

Allow User Abort [ off ]

Enter Find Mode [ ]

Set Field [ ShipDate ; Get(CurrentDate) - 10 & "..." & Get(CurrentDate) - 7 ]

Set Field [ TagField ; 1 ]

Perform Find [ ]

If [ not Get(FoundCount) ]

Show Custom Dialog [ OK ; "No Shipments found." ]

Exit Script

End If

Go to Layout [ whatever ] and do your work

To give you more control, enter the find date range directly into the ShipDate field yourself. You would remove the Set Field [] and just pause your Enter Find Mode [ Pause ] and type your find requests instead like 10/1/2005...10/7/2005. Much depends upon how this process will be used, when it will be used, and what you want to do with the information once you get it.

LaRetta