Return to FileMaker.com
00012/005/1955 should not be a valid date
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.
1. Create a Date field
2. Enter leading 0's in the month or day like "00012/005/1955"
Either error or trim the 0's.
Allows that text
Have auto enter calc with override as:
Month (Self) & "/" & Day (Self) & "/" & Year (Self)
Retrieving data ...