Searching in Find Mode

[kenneth2k1]

Hello:

Vaughan was kind enough to help me with a script, but I'm having a problem with one part:

Set Field ["Letters P Date 4" , "<=" & Status(CurrentDate) - 4]

While in Find Mode, this should set the "Letters P Date 4" field to read "<= 12/16/01" if it were ran today, right?? Instead, it appears to be excluding the "<=" sign altogether. I put a pause script step just after this step, and manually put the sign in. It then yields the results I want. Any Ideas as to why it's not working??

Thanks alot, guys

Ken

[BobWeaver]

Unfortunately, this is one situation where you can't use "Set Field" because the Set Field won't allow a non-date character ("<=" in this case). You have to use "Insert Calculated Result" instead.

Insert Calculated Result[select, "Letters P Date 4" , "<=" & DateToText( Status(CurrentDate) - 4)]

You have to make sure that the field "Letters P Date 4" is on the current layout and access to the field is allowed.

[kenneth2k1]

Thanks for the reply, Bob

You've come to the rescue once again.

Ken