Problems with setting Find criteria

[Regulatory Affairs]

How can I Find records that have a blank in the Committee Action field? The only values for the field are either Admitted or Rejected. Records for which no action has yet been taken are blank. I've tried =" ", ="", = . I wasn't able to do it on a layout either.

For another report I want to list applications received since the last review date, which the user would input when running the script. The script I've written runs correctly, but I want to limit it to those with a File Started Date greater than a date from the user.

Thanks bunches!!!

[Tim W]

Hi,

In a script the = must be in quotes for a text field like so.

Set Error Capture [on]

Allow User Abort [off]

Show All Records

Enter Find Mode []

Set Field [YourField; "="]

Perform Find []

If ( Get(LastError)= "401")

    Show Custom Dialogue ["NRF";"No Record Found."]

End If

The same would hold true for the set field step to insert a date criteria, like so.

Set Field [YourDate; GetAsText("> "&EnteredDate)]

HTH,

Tim

Edited May 30, 2007 by Guest