Product:  ImportOmatic 

Description: 'Invalid Fuzzy Date' exception when importing from .xls  and .xlsx files

Environment: All

Version: ImportOmatic version 3.0 and higher 


Answer: 


Excel includes a hidden timestamp along with the day, month, and year to a cell that is meant to store dates. When that is in the process of being imported, the timestamp will make an exception for the row with the date. 


The best 2 solutions are: 


1. Save the file as a .cvs


2. Include a leading apostrophe ( ' ) in front of the date in each cell with one as shown in a screen shot below, save and attempt to import again