Working with data in date fields
When entering data in date fields, type dates as follows:
 •
Enter the date in the system format used when the file was created.
 •
Type one date on one line in each field.
 •
Type the day, month, and year as numbers separated by a backslash or other separator character. (Use the same character for each separator; for example, 2/3/2014. You can use any character as a separator except a letter, a colon (:), or a “+” sign.)
 •
If enabled, use the drop-down calendar to select a date. Use the month and year controls to locate the desired date and then select it to close the calendar. The date is inserted using the current date format. For more information, see Setting up a field to display a drop-down calendar.
 •
FileMaker Pro supports dates ranging from 1/1/0001 to 12/31/4000.
Notes
 •
If you don't type a year in a date field and you haven't typed a separator character for a year, FileMaker Pro enters the current year. If you enter dates with two-digit years, such as 5/12/14, FileMaker Pro converts them to four-digit years, as described in Conversion of dates with two-digit years.
 •
Use Control Panel (Windows) or System Preferences (OS X) to change the day on which a week begins in a drop-down calendar.
Related topics 
Entering Japanese Emperor Year dates
About date fields
Specifying formats for date fields
Setting options for fields
Inserting the current date or other variables into a field
Was this topic helpful? Send feedback.