Specifying formats for timestamp fields

Contents > Editing objects on layouts > Selecting and working with objects on a layout > Specifying formats for timestamp fields

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 Format dialog box

Time (excluding the seconds portion)

Time Format dialog box

Seconds (including any fractional seconds)

Number Format dialog box

To specify formats for timestamp fields:

1.	In Layout mode, select one or more timestamp fields.

For more information, see Selecting objects.

2.	To format the date component, choose Format menu > Date, select the formatting options you want, and click OK.

For more information, see Specifying formats for date fields.

3.	To format the time component (except the seconds portion), choose Format menu > Time, select the formatting options you want, and click OK.

For more information, see Specifying formats for time fields.

4.	To format the seconds and fractional seconds component, choose Format menu > Number, select the formatting options you want, and click OK.

In the Number Format dialog box, only two options affect the display of the seconds component: Fixed number of decimal digits and Decimal separator. The remaining options have no effect. For more information, see Specifying formats for fields containing numbers.

Notes

You must specify formats for date and time components before any formatting will be applied.

For more information about defining timestamp fields, see Defining timestamp fields.

Contents > Editing objects on layouts > Selecting and working with objects on a layout > Specifying formats for timestamp fields