Auto-Enter Calculation

Discussion created by TKnTexas55 on Jun 29, 2018
Latest reply on Jul 2, 2018 by TKnTexas55

I have a number of imports to FileMaker Pro 17 tables, that our coming from out accounting system exports, via Excel.  I have one problem that I cannot resolve.  When I import some date fields will have #NUM! (see below). This means blank data.  I want to have an auto-enter calculation to blank these instead of using what the system passes.  This is a snip from the import Excel.   Credit Memos do not have a Due Date.