Hi:

I am trying to write a script that finds records with a dollar value 
in the field Other_Dollars_2007.  For the found records, if the field 
Other_Date_2007 is empty, the value is set to 4/1/07.
  
It finds the correct records but does not insert the specified date in 
the date field.  There are records where the field Other_Date_2007 
appears empty but obviously has some value in it.  Rather than 
inserting 4/1/07 it inserts "?".  

Here is the relevant portion of the script.

Perform Find [ Specified Find Requests: Find Records; Criteria: Dollar 
Donor Related::Other Dollars 2007: “> 0” ] [ Restore ] 
Set Variable [ $Found_Count; Value:Get(FoundCount) ] 
Set Variable [ $Loop_Count; Value:0 ] 
Go to Record/Request/Page [ First ] 
Loop 
   If [ Dollar Donor Related::Other_date_2007 < 1/1/1988 ] 
      Set Field [ Dollar Donor Related::Other_date_2007; 4/1/2007 ] 
   End If 
   Set Variable [ $Loop_Counter; Value:$Loop_Counter + 1 ] 
   Exit Loop If [ $Loop_Counter = $Found_Count ] 
   Go to Record/Request/Page [ Next ] 
End Loop 

Any suggestions?

Thanks.

Charlie

Reply via email to