User`s guide
2.
In the Options dialog box, click the Fields tab.
3.
Click the button appropriate to the type of field you want to format (String, Number, Currency, Date,
Time, Date and Time, or Boolean).
The Format Editor appears.
4.
Use the Format Editor's tabs to specify the formats you want.
5.
Click OK.
11.5.4.2 Setting default formats for Date, Time, and Date and Time fields
The following procedures first describe how to specify standard formats for Date, Time, and Date and
Time fields, and then describe how to customize the formats for such fields.
Note:
These default settings will affect only the objects that you subsequently add to a report. To format fields
that you've already added to a report, you must right-click the field in the report and select Format Field
from the shortcut menu.
11.5.4.2.1 To set standard default formats for Date, Time, and Date and Time fields
1.
On the File menu, click Options.
2.
In the Options dialog box, click the Fields tab.
3.
To open the Format Editor, click the button appropriate to the field you want to format (Date, Time,
or Date and Time).
Note:
If you click the Date and Time button in the Format Editor, then any subsequent changes will affect
"Date and Time" fields only. You must click Date or Time to format independent date fields or time
fields.
4.
In the Format Editor dialog box, click the Date and Time tab.
5.
Select a predefined format from the list (or click Customize to create your preferred format). When
you click a new format, you can preview the results in the Sample area of the Format Editor.
Note:
From the list of predefined formats, you can choose the System Default settings to ensure that
Crystal Reports uses the formats dictated by Windows. You can alter your system's settings in the
Regional Settings Properties dialog box, located in the Control Panel.
6.
Once you've selected a format, click OK in the Format Editor dialog box.
7.
Click OK in the Options dialog box.
Now, when you add Date, Time, or Date and Time fields to a report, Crystal Reports should use the
format you specified.
2012-03-14242
Formatting