I’m not sure if I’m posting this in the right area but here goes.
I use find and replace to update many 10s of records with some basic items I need to update a date field from a blank record but I cannot seem to specify it in the find and replace options the blank / empty date fields. If I enter a spurious date i.e. 01/01/04 into the fields, find and replace works great, if I try to enter, Is Null or "" or " " then I get no records found to replace? any help appriciated.
I use find and replace to update many 10s of records with some basic items I need to update a date field from a blank record but I cannot seem to specify it in the find and replace options the blank / empty date fields. If I enter a spurious date i.e. 01/01/04 into the fields, find and replace works great, if I try to enter, Is Null or "" or " " then I get no records found to replace? any help appriciated.
