AnsweredAssumed Answered

00012/005/1955 should not be a valid date

Question asked by woodstock_1 on Nov 16, 2012

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)

Outcomes