Change the properties of a date or time object

1. Report Designer > select the object you want to change.
2. Properties pane > Formatting > finder button .
   
   

   Tip: If you have chosen to auto-hide any of your Report Designer panes, the name appears in a tab to the left or right of your window. To expand a pane, click on its name. If you have closed any of your Report Designer panes, to open them, from the View menu, choose the relevant pane.

3. Date & Time tab > amend the settings as required > OK.
   
   For a detailed explanation of the date formatting and time formatting options, please refer to the following section, The date and time options.
   
   

   Tip: You can choose a format from the drop-down list, or manually enter the required format.

You have now amended the properties of the date or time object on your report. You should make any further changes required then save your report. For further information about how to save the amended report, please refer to the section To save the changes to your document later in this article.

The date and time options

There are many different date and time formats available from the drop-down lists within the Date & Time tab. The following rules apply when specifying a date or time format:

Tip: You can choose a format from the drop-down list, or manually enter the required format following the rules below.

d	Specifies the format used for the day. A single d displays the correct date, but suppresses the leading zero, where applicable, for example, the first of the month appears as 1.
dd	Displays a leading zero where applicable, for example, the first of the month appears as 01.
ddd	Displays the day name in a short text format, for example, Monday appears as Mon.
dddd	Displays the complete day name in text format, for example, Monday appears as Monday.
M	Specifies the format used for the month. A single M displays the correct month, but suppresses the leading zero, where applicable, for example, January appears as 1.
MM	Displays a leading zero where applicable, for example, January appears as 01.
MMMM	Displays the complete month name in text format, for example, January appears as January.
yy	Displays a leading zero where applicable, for example, 2009 appears as 09.
yyyy	Displays the complete year, including the century, for example, 2009 appears as 2009.
H	Specifies the format used for an hour. A single H displays the correct hour, but suppresses the leading zero, where applicable, for example, one AM appears as 1. An upper case H is used to specify the 24 hour clock format.
HH	Displays the leading zero where applicable. For example, one AM appears as 01. An upper case HH is used to specify the 24 hour clock format.
h	Specifies the format used for an hour. A single h displays the correct hour, but suppresses the leading zero, where applicable, for example, one o'clock appears as 1. A lower case h is used to specify the 12 hour clock format.
hh	Displays the leading zero where applicable. For example, one AM appears as 01. A lower case hh is used to specify the 12 hour clock format.
mm	Displays the number of minutes. This is always displayed as two digits.
ss	Displays the number of seconds. This is always displayed as two digits.
tt	Displays whether the time is AM or PM when using a 12 hour clock format. This is always used in conjunction with the 12 hour clock format listed above.
Separator	/ or - are the most common but you can enter other characters or spaces if required.
Text	You can enter text surrounded by quotations. For example, dd, MMMM "in the year" yyyy displays 01, January in the year 2013

Display calculated times as number of days - Where dates are used in an expression, to show the calculated time in days, select this check box.

To save the changes to your document

1. Report menu > Report Properties > enter a new name and description for the document > OK.
   
   Report Designer v1.3 and below - Report Explorer pane > select the document name > Properties pane > Name > enter a new name for the document > Enter.
   
   

   Tip: You can check your Report Designer version in Help > About > Application > File Version.

2. File > Save As > File name > enter a new name for the document > Save in > browse to the required location for your document. For further information about where to save your document, please refer to article .
   
   
3. Save > File > Exit.

You have now saved your amended document.

Tip: If you have any difficulty finding a recently saved document, you can open it from the Report Designer Recent files list and save it to the required location. To open a recently viewed report, from the main program, open the Tools menu, choose Report Designer then from the Recent files list, click your required report.

---