AnsweredAssumed Answered

Find script on many fields using "or"

Question asked by ElizabethKennedy on Aug 2, 2010
Latest reply on Aug 2, 2010 by philmodjunk

Title

Find script on many fields using "or"

Post

Hi,

I have records that contain testing dates for products.  Each product has to be tested at various times in the future.  I have a series of fields date_1_mo, date_2_mo, date_6_month, etc.  I would like to develop a script that will find testing dates within a given period of time. 

I wrote a script using the script maker that looks like this (with more similar "set field" lines containing the other fields) but the script seems to be assuming an "and".  I would like to get it to us "or".  That is, if any of the test date fields occur within the next 30 days, I would like the record returned.

Enter Find Mode [ ]
Set Field [ Testing Dates::date_1_mo; Get ( CurrentDate ) & "..." & Get ( CurrentDate )+30 ]
Set Field [ Testing Dates::date_2_mo; Get ( CurrentDate ) & "..." & Get ( CurrentDate )+30 ]
Set Field [ Testing Dates::date_3_mo; Get ( CurrentDate ) & "..." & Get ( CurrentDate )+30 ]
Set Field [ Testing Dates::date_6_mo; Get ( CurrentDate ) & "..." & Get ( CurrentDate )+30 ]
Perform Find [ ]

 

 

Can anyone help me?  Am I even close?

Libby

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Outcomes