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

    Replace NULL in timestamp field

    sccardais

      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?