Specifying formats for timestamp fieldsTimestamp 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:
1. In Layout mode, select one or more timestamp fields.
2.
3. To format the date component, in the Data Formatting area, click Date , and then select the formatting options you want.
4. To format the time component (except the seconds portion), in the Data Formatting area, click Time and select the formatting options you want.
5. To format the seconds and fractional seconds component, in the Data Formatting area, click Number , 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. For more information, see Specifying formats for fields containing numbers.
• 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.