The calendar starts at the date in the field...or the current date if the field is blank.
One way to start earlier is to Setfield via script, then enter the field..
If you make the field itself a button (or drop a transparent button over it that doesn't cover the calendar) that runs a script:
If (IsEmpty (Datefield) )
Setfield (Datefield ; "1/1/1962" )
You may get what you're looking for.
Be careful though that you don't have a ton of records with DOB = 1/1/1962...always a danger when using a method like this. People get lazy.
I find that entering dates far different from today's dates are often easiest handled by just not using the calendar pop up. The user can simply type in the date and FileMaker will automatically catch invalid dates. This works best, however, if all your users automatically expect to enter dates consistent with your system's locality settings (always MMDDYYYY or always DDMMYYYY).
Thanks to both of you for that. I think you are probably right Phil, the drop down seems like a nice idea and works in some scenarios but this probably isn't one of them.
How can I set this up finding data from a field of first date and most recent date. Example: I have a field named BodyAgeDate, with one field in it named Weight. I want to set up Beginning Weight and Current Weight fields where it would take the data from Weight and populate the Beginning Weight and Current Weight.
BodyAgeDate 7/12/2013; Weight 233 --> This would be Beginning Weight
BodyAgeDate 8/12/2013; Weight 200 ---> If for some reason 7/12/2013 record was deleted or changed to later date, 8/19/2013, then this would be Beginning Weight
BodyAgeDate 8/22/2013; Weight 220
BodyAgeDate 9/2/2013; Weight 190 ---> This is the most current/recent weight
So for Beginning Weight field it would calculate to be 233
Current Weight field it would calculate to be 190
I suggest that you start a new thread as this is a different question. When you make that new post, please include a more detailed description of how you have organized your data into tables.