>can anyone tell me the proper way to find a date field that is empty. when i tried locate for isempty(date_field), foxpro didn't like it. any help would be appreciated. thanks.
You can check for date_field = {}. This expression could be Rushmore optimizable if you've index on date_field. You can also use EMPTY(date_field) but it's not optimizable.
--sb--