i want to run a script that will seache the"OrderDate" field for "in Process" but i cant figure out how to do it.

i need to find all those orders and delete them.

Thanks for any help.

Hi

I'm guessing at the structure of this field, but you could try finding the dates and then omit them leaving the not date stuff. In other words, in the "OrderDate" field, do a find > 1/1/1900 with the omit box checked. This should leave the non date info such as In Process.

I hope you are changing how the In Process information is handled in the future.

HTH

Lee

how do i do a find in a script?

Since this is a one time occurrence (or should be) I wouldn't make a script, Although in order to create a script you would still have to do it manually first anyway. But first do this

Enter Find Mode, go to field OrderDate, insert the = sign and check the box Omit and then hit the continue button.

If you still want a script, then Go into ScriptMaker and create a script with a find. That's it, as long as you don't do a different find before you make the script.

HTH

Lee