Jump to content

Searching in Find Mode


This topic is 7243 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 7243 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.