Controlling date and time format displayed in result sets
Specify user preferences to control the date and time format displayed in a query result set (on-screen, printed, and exported).
About this task
Note: Settings that you specify through Preferences apply
to the current user only. The date and time settings you specify also
apply to the history and reference list controls on a record form.
To specify the date and time format displayed in a result set:
Procedure
- From the menu, click Preferences.
The User Preferences window opens.
- In the User Preferences window, select the Result tab.
- Set the Result set date format to Long
Date, Medium Date, or Short
Date.
- Long Date displays
Month DD, YYYY HH:MM:SS AM/PM time zone offset
where the time zone offset corresponds to the time zone of the current user. (Example:June 15, 2000 12:00:00 AM GMT+08:00
) - Medium Date displays
Mon DD, YYYY HH:MM:SS
. (Example:Jun 15, 2000 12:00:00 AM
) - Short Date displays
MM/DD/YY HH:MM AM/PM
. (Example:06/15/00 12:00 AM
)
- Long Date displays
- Click Save.The properties you set become effective immediately.
What to do next
After you change the preferences, open a result set to see the changes.