Searching On Blank Fields

[TechRangerBrad]

Hello,

Kind of a dumb question - I am creating a script that needs to find all of the records with a blank field. In my case it is a service_date field. Anybody have an idea on how to do this? I have tried service_date= to no avail along with service_date="" and service_date=" " Any help would be greatly appreciated.

B

[Lee Smith]

Use the script step Perform Find. Describe the find request as

Select your date field, and then select the symbol of = (Equal Exact Match), click the Add button, and then Okay.

HTH

Lee