AnsweredAssumed Answered

Replace NULL in timestamp field

Question asked by sccardais on Apr 30, 2016
Latest reply on Apr 30, 2016 by 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?

Outcomes