My table includes several timestamp fields created from an SQL export from another system. These fields contain a timestamp or "NULL".
After import, FileMaker doesn't like the presence of a text value in a timestamp field.
When I try to search and replace NULL in this timestamp field, FileMaker won't allow it because it's expecting a timestamp value in the search criteria.
I'd like to replace all NULL values in my timestamp fields with blank ( "" ).
Is there way to do this?