Sage 200 Report Designer - How to amend date or time object properties

Summary

On reports and layouts, any variable or expression with a date or time function displays the format that is set in the date and time properties. This article explains how to change the properties of a date or time object on your document.

Description

NOTE:

This article has been prepared and issued to you as a goodwill gesture only and Sage accepts no liability or responsibility for its use. For further support please refer to your Business Partner.

 

Resolution

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.

If you are viewing this article from the Sage website, a list of Sage 200 Report Designer articles are available now.

 

Upgrade your licence

Growing business? Add more companies, users, or employees to your licence with ease. Leave your details and we’ll be in touch.

Image

Solution Properties

Solution ID
200427112322844
Last Modified Date
Thu Mar 19 12:43:42 UTC 2026
Attributes
Product Details
Modules: Inventory Optimization
Modules: Project accounting
Modules: Bookkeeping for clients
Modules: Report Writer
Modules: Bank feeds
Modules: Customers
Modules: Customer information
Modules: Contact Management
Modules: Order Entry
Modules: Purchases
Modules: Suppliers
Modules: Payroll solutions
Modules: Bank Manager
Modules: Tax
Modules: VAT
Modules: Sales
Modules: Point of Sale
Views
0