Help

Adding and viewing data
F
ILEMAKER PRO HELP 78
Notes
• FileMaker recommends that you only enter dates into fields defined with the Date type.
Don’t use text or numeric fields to store dates. FileMaker software is not intended to support
dates in such fields.
• FileMaker Pro supports the entry of dates ranging from 1/1/0001 to 12/31/4000.
• If you need to enter the creation date or modification date for a record, use auto-enter
options, which are more accurate and easier than entering the data by hand. For more
information, see
Defining automatic data entry.
• In FileMaker Pro 3.0 through 5.5 and FileMaker Pro 6.0v3 and 6.0v4, the processing of
dates with two-digit years is different depending on how they are entered. Also,
FileMaker
Pro 6.0v1 and 6.0v2 have some date handling issues that are corrected in
FileMaker
Pro 6.0v4.
Working with data in time fields
When entering data in time fields, type the date in the system format used when the file was
created. Type the time of day (or time duration) as one of the following:
• hours: 12
• hours and minutes: 12:20
• hours, minutes, and seconds: 12:20:45
• hours, minutes, seconds, and fractional seconds: 12:20:45.89
Notes
• If you type a single digit, FileMaker Pro assumes it's the hour (typing 5 in a time field
indexes it as 5:00:00).
• Type the time of day in 24- or 12-hour format, with or without AM or PM. (AM is assumed for
a time less than 12:00).
• You can type a negative time duration in a time field, like –08:40:00. You can't type a
negative time if Strict data type validation is defined for the field options. See
Defining field
validation.
• For more information on system formats, see Opening files with different system formats.
• Each time field parameter (hours, minutes, and seconds) can store values up to
2
31
- 1 (2,147,483,647).
• For ODBC data sources, the time field parameters are restricted. Minutes and seconds
must be in the range of 0 to 59, and hours must be in the range of 0 to 23. Negative time
values are not supported.
Related topics
Finding numbers, dates, times, and timestamps
About time fields
Specifying formats for time fields
Setting options for fields
Inserting the current date or other variables into a field