Fields that contain dates or times can be formatted to control their appearance. Although dates and times are usually displayed in fields that have the Date/Time data type (see Date/Time data type), they can also be the result of calculations in fields with the Calculated data type (see Calculated data type). Dates and times are formatted in a similar way in any field that can contain them.
To format the Date:
Select the Year format by choosing from Long Form e.g. 1999, Short Form e.g. 99, & None.
Select the Month format by choosing from Long Name e.g. January, Short Name e.g. Jan, & Digits e.g. 01.
Select the Order by choosing from Month/Day e.g. Jan/12, & Day/Month e.g. 12/Jan.
Select the Separator type by choosing from \ - . / or blank e.g. 12-05-99, 12.05.99, 12/05/99, 12 05 99, etc.
To format the Time:
Select the Add Time checkbox to add time to the date.
Select 0..12 to display AM/PM rather than the 24-hour clock e.g. 03:45 PM rather than15:45.
Select Seconds to display seconds as well as hours and minutes e.g. 15:45:34.
If you only want to display the time, select Time rather than Date in the left-hand box and proceed as shown above.