Scripting_ Search Date Range_based off global

[buckbuck]

I have a script that finds set based on Field: Date Ordered, where

 

(based on a LaRetta solution)

 

Field: "C_Tax Period": Calculation: Indexed: Year (Date Ordered)"." (Month (Date Ordered)/100)

Field: g_Tax Period: Global  - this appears on the layout with a List Value attached based on c_Tax Period result

 

with a button, Perform Script: Find Tax Period, where

 

Enter Find Mode

Set Field: c_Tax Period; g_Tax Period

Perform Find

 

This gives me all Orders within a defined date range.

 

Question: How can I constrain or modify this found set to all Contacts: Country ="Canada"

 

It seems like I have two Finds but I cannot find the right syntax to constrain the set.

 

Hope this makes sense.

 

Thank you for any suggestions or solutions.

[comment]

Why don't you do it all at once:

 

Enter Find Mode [ ]

Set Field [ c_Tax Period ; g_Tax Period ]

Set Field [ Country ; "Canada" ]

Perform Find [ ]

 

 

To constrain an existing found set, do:

 

Enter Find Mode [ ]

Set Field [ Country ; "Canada" ]

Constrain Found Set [ ]

[buckbuck]

I have an on going topic under the title:

Scripting Search Date Range, range calculated result from text

In this Invoice search, a query is based on a global based on a field calculation used within a script to find records within the month, year and quarter ending - yes a run on sentence.

 

In my Invoice Table setup I have a system for tracking payment against all open invoice. I create three fields Payment 1, Payment 2, Payment 3 and three corresponding date fields Date1 Date 2 Date 3 to accrue the deposit, payment and balance. This might not be the best system but it was all I could figure out to manage the payments.

 

Now what I want is a script that will populate the Date 1 Date 2 and Date 3 with the global.

 

How is this possible.

RDE Test2.fp7.zip

[Lee Smith]

Please do not double post your question.

 

I have merged your two topics.

[comment]

I create three fields Payment 1, Payment 2, Payment 3 and three corresponding date fields Date1 Date 2 Date 3 to accrue the deposit, payment and balance. This might not be the best system

 

No, it is not a good system, because now you need to create a separate find request for each Date field. You should have another table for Payments, where each payment would be a related record.

 

 

 

 

 

I have merged your two topics.

 

It's actually three topics:

http://fmforums.com/forum/topic/82047-scripting-search-date-range-range-calculated-result-from-text/

[Lee Smith]

Arn't the OPs different?

[comment]

Sorry, wrong link - fixed now, I hope.