Specifying formats for timestamp fields
Timestamp fields store both a date and a time, such as when a record was created or last modified. You format a timestamp field by separately formatting its three components:
 
Timestamp field component
Format using
Date
Date area of the Inspector
Time (excluding the seconds portion)
Time area of the Inspector
Seconds (including any fractional seconds)
Number area of the Inspector
To specify formats for timestamp fields:
1.
In Layout mode, select one or more timestamp fields.
For more information, see Selecting objects.
2.
Click Inspector Inspector button in the layout bar, then click Data.
3.
To format the date component, in the Data Formatting area, click Date Date button, and then select the formatting options you want.
See Specifying formats for date fields.
4.
To format the time component (except the seconds portion), in the Data Formatting area, click Time Time button and select the formatting options you want.
See Specifying formats for time fields.
5.
To format the seconds and fractional seconds component, in the Data Formatting area, click Number Number button, then select the formatting options you want.
In the Number area, only two options affect the display of the seconds component: Fixed number of decimals and Separators. The remaining options have no effect. See Specifying formats for fields containing numbers.
Notes
 •
You must specify formats for both date and time components before any formatting will be applied. If you select As entered for either Date or Time, the data in the timestamp field appears the way it is entered.
 •
To format timestamps based on the current system formats when the file is opened, select Short System Date (for example, 11/11/2014) or Long System Date (for example, Tuesday, November 11, 2014) and Short System Time (for example, 8:23 AM) or Long System Time (for example, 8:23:54 AM).
 •
For more information about defining timestamp fields, see About timestamp fields.
Was this topic helpful? Send feedback.