Skip to main content Skip to complementary content

Setting the display format of dates and numbers


Talend Studio enables you to decide the format according to which you want to display/insert dates or numbers in different languages in master data records in Talend MDM Web UI.

Information noteWarning: You must use a syntax based on the java.util.Formatter class to define the display of dates and numbers in a specific language. For further information about this class, see Oracle documentation.

Before you begin

You have already created data models, business entities and attributes in the data model. For further information, see Creating a data model, Creating business entities in a data model and Adding attributes to the business entity.

About this task

Consider as an example that your data model holds the Agent entity and that you have created an attribute in this entity, StartDate, to display the start date of the agent.

To set the display format of dates in the English and French languages, do the following:


  1. In the data model editor, expand the Agent entity and browse to the StartDate attribute.
  2. Right-click StartDate and select Set the display format.
    A dialog box is displayed.
  3. From the language list, select the language for which you want to define the date format.
  4. In the field to the right, enter the syntax for the date format according to the java.util.Formatter class.
    In this example, enter %tc for the English language and %1$td/%1$tm/%1$ty for the French language.
  5. Click the plus button to add each of the two lines to the list below the fields, and then click OK to close the dialog box.
    The two annotations display below the selected attribute.


When a business user accesses the Agent record through Talend MDM Web UI, the start date will be displayed in the following format in English:

The start date will be displayed in the following format in French:

You can follow the same procedure to set the display format of numbers. For example, assume that the actual value in the database is 2.5 (XSD standard); if you define the format in English as the following %-10.4f, the result in the web application will be 2.5000. And if you define the format in French as the following %-10.4f, the result in the web application will be 2,5000.

Information noteNote: Java automatically substitutes the local-specific decimal separator.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!