Skip to main content Skip to complementary content

Changing the calendar

Talend Data Preparation allows you to easily switch from one type of calendar to the other with the Convert date function.

In this example, you are preparing some customer data that needs to be sent to one of your Japanese clients. Your dataset includes client information such as names, phone numbers, email addresses, but also the date on which they subscribed to a specific service.

Dataset containing client information.

You can see that in this dataset, the subscription dates have been entered using the dd/MM/yyyy format of the Gregorian calendar. Because the preparation is aimed at the Japanese market and you want to make it more adapted to this target, you will convert these dates to the Japanese calendar.

Procedure

  1. Click the header of the Subscription date column to select its content.
  2. In the Functions panel select Convert Date.

    The menu for the corresponding function opens.

  3. In the Source calendar drop-down list, select Gregorian calendar.
  4. In the Target calendar drop-down list, select Japanese calendar.
  5. Click Submit to apply the function on the column.

    You have the possibility to output the result of this function in a new column by selecting the Create new column check box.

Results

The subscription dates are now using the Japanese calendar, and you preparation is more adapted to your client.

Dataset containing client information with SubDate column highlighted.

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 – please let us know!