Date/Time Format Properties

Formatting options for the selected Date/Time object or objects.

To apply formatting options to more than one object, press [Shift] and click on the desired objects in the layout.

To apply formatting options to all the objects in one layout section, click in the section and select Edit, then Select All.

Property	Description
Date Format	None =Do not print the date. DD-Mon-YYYY = 07-Dec-1999 MM/DD/YYYY = 12/07/1999 DD/MM/YYYY = 07/12/1999 YYYY/MM/DD = 1999/12/97 MM/DD/YY = 12/07/99 DD/MM/YY = 07/12/1999 YY/MM/DD = 99/12/07 DATE-EDIT-MASK = Use the settings defined in SQR.INI. To do this, set a Locale in [Default-Settings] by using the syntax locale=US-English. Several locales are available by default, or you can define your own. For more information on defining Locale and DATE_EDIT_MASK in SQR.INI, see Volume 2 in the Hyperion SQR Production Reporting Developer's Guide.
Time Format	None = Do not print the time. HH:MI PM = 11:32 PM HH:MI = 23:32
Alias	Enter or change the alias. An alias is an alternate name for a column. For example, an alias forstor_address could beStore Street Address. To view aliases in the layout, select View, then Alias.

Property

Description

Date Format

None =Do not print the date.

DD-Mon-YYYY = 07-Dec-1999

MM/DD/YYYY = 12/07/1999

DD/MM/YYYY = 07/12/1999

YYYY/MM/DD = 1999/12/97

MM/DD/YY = 12/07/99

DD/MM/YY = 07/12/1999

YY/MM/DD = 99/12/07

DATE-EDIT-MASK = Use the settings defined in SQR.INI. To do this, set a Locale in [Default-Settings] by using the syntax locale=US-English. Several locales are available by default, or you can define your own. For more information on defining Locale and DATE_EDIT_MASK in SQR.INI, see Volume 2 in the Hyperion SQR Production Reporting Developer's Guide.

Time Format

None = Do not print the time.

HH:MI PM = 11:32 PM

HH:MI = 23:32

Alias

Enter or change the alias. An alias is an alternate name for a column. For example, an alias forstor_address could beStore Street Address. To view aliases in the layout, select View, then Alias.

Note:

To define default date/time properties, selectFile/Edit, then Preferences and enter the information under Date/Time in the Layout Preferences tab.