0 Replies Latest reply on Nov 16, 2012 8:25 PM by woodstock_1

    00012/005/1955 should not be a valid date

    woodstock_1

      Summary

      00012/005/1955 should not be a valid date

      Product

      FileMaker Pro

      Version

      All

      Operating system version

      Any

      Description of the issue

      Date fields allow many leading 0's for the Month or Day. Seems like a small issue but becomes more of an issue when transferring data between FileMaker and other databases.

      Steps to reproduce the problem

      1. Create a Date field
      2. Enter leading 0's in the month or day like "00012/005/1955"

      Expected result

      Either error or trim the 0's.

      Actual result

      Allows that text

      Workaround

      Have auto enter calc with override as:

      Month (Self) & "/" & Day (Self) & "/" & Year (Self)