Jump to content

Date entry


This topic is 8515 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I handle registrations for a boy's camp.

One field that is entered is the boys birth date. Since FileMaker treats a 2 digit year from 00 to 89 as a 20xx year, there are often incorrect entries if someone (often me) forgets to put in all 4 digits for the year. I have set up the field name (birthdate) to change to ERROR if this happens, but this is not sufficient to be noticed easily. Is there a way to make it change to red or flash or some other way to make it obvious that an error has been made?

Dave

Link to comment
Share on other sites

Use field validation. In define fields, select the date field in question, and click options. Click the Validation tab and select "Strict data type" and "4-Digit Year Date" from the pop-up menu. You can also select from the bottom area "Strict: Do not allow user to override data validation." You should also probably display a custom message if the validation fails since FileMaker's dialog is usually not very helpful.

For those dates that have already been entered incorrectly, check out this link:

http://www.fmforums.com/ubb/Forum16/HTML/000125.html

Chuck

Link to comment
Share on other sites

This topic is 8515 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.