AnsweredAssumed Answered

Issue with ESS (SQL Server) and 'invalid' date

Question asked by fabriceN on Dec 18, 2014
Latest reply on Jan 7, 2015 by TSGal

Summary

Issue with ESS (SQL Server) and 'invalid' date

Product

FileMaker Server

Version

13v5

Operating system version

Windows Server 2012 64bits

Description of the issue

Just ran into an issue while pushing data to a SQL Server database.
The user had erroneously entered a date like 1/1/0214 (instead of 2014), which is stil a valid date for FileMaker, but which throws a 1408 error 'unable to convert date or time from string' (or something like that..

Outcomes