One field in my database indicate record's status. I flag this field with "New" when a record is created. the flag should be changed to "Old" two days later. I try to run a script as:

goto record/request/page [first]

loop

go to field["status"]

if [current date - created date > 2]

Perform Find/Replace["New", "Old", "Replace"]

end if

goto record/request/page [exit after last, next]

end loop

But seems the Perform Find/Replace[] doesn't work.

Help me please!!!

Why not have it do it automatically. Just make the "status" field a calculation:

Case(Date +2 >= Status(CurrentDate), "New",

Date < Status(CurrentDate) + 2, "Old" )

Lee

Brilliant! but how can I do this if I have two different flags in this field (Sorry, I forgot mention in my first post).

then simply add a

&" " & If(condition for flag2,result1,result2) after Lee's calculation.

Thanks lee and cjaeger. I thought the 2nd flag would replace the 1st one.