2 Replies Latest reply on Jan 7, 2015 2:23 PM by TSGal

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

    fabriceN

      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..