Find Script

[RickK]

This one's got me. I've written a script that does not work quite right. There are two search criteria's, the first works and second doesn't (set fields).

The second set field is going into a field that is date formated and used as a record modification date field. It is inserting from a global (gSymbol1) ">=" and the current date - 2

This field, if searched manualy works OK, but the script fails here.

I've tried using a calclation here and insert text or insertcalculation without luck.

Any suggestions?

Thx

------------------------------------------------------------------------------

If [ Status(CurrentMessageChoice) =1 ]

Enter Find Mode

Set Field [ StatusCode, gFindPlated ] #This works OK

Set Field [ StatusCode, gSymbol1 & Status(CurrentDate) -2] #This is the trouble spot

Perform Find

Go to Layout [ Table View ]

Toggle Window

[ Maximize ]

Exit Script

Else

------------------------------------------------------

[LiveOak]

Yup! One of the nasty little "features" of FM. You need:

Insert Text(StatusCode, select, ">=")

Insert Calculated Result(StatusCode, Status(CurrentDate)-2)

Make sure the Status Code field is showing on the current layout when using these steps.

I think the problem is that a SetField to a date field requires the result to be converted to data type "Date", special symbols are not part of a valid date. Insert commands don't force this parsing to occur.

-bd

[RickK]

Thanks, That worked. I guess where I got hung up is in applying the operator ">=" to the current date.