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