New Date Format dialog

Use this dialog to create a new date format. For example, you might want to create a new format for Year containing the last two digits only of a typical four digit year: e.g. display 01 for 2001, display 02 for 2002 and so on.

You can use the new format in date hierarchies.

For more information, see:

"What are date hierarchies?"

"What are date items?"

"What are date format masks?"

Date format group

Use this drop down list to choose the group in which you want the new date format to be included.

New Format

Use this field to enter the date format mask that you want to use. For example, Mon-YYYY to display the month plus the four digits of the year.

Notes

• A new date format must confirm to the SQL Date Format Model, for example YYYY, YYY, YY, RR etc.

• You can prefix a new Date Format with descriptive text inside "quotes" (E.g. "Fiscal Year" YYYY ).