9 Replies Latest reply on Apr 30, 2016 12:17 PM by sccardais

    Replace NULL in timestamp field


      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?