Convert year-month-day date format to year-month

1. Overview

1.1 Expected effect

The effect of converting the year-month-day date format to month is shown in the following table.

1.2 Implementation idea

1）In the Self-Service dataset, add the date field that needs to be converted.

2）In the new column, add a combination of the REPLACE function and the LEFT function to get the year and month format.

2. Operation steps

Example data: "Industry Data>Estate Indusrty>FACT_SALE_CONTRACT"

2.1 Create a new Self-Service dataset

Process the data in the Self-Service dataset. Click "Data Preparation" and add "Self-Service dataset" under "Package". As shown in the figure below.

2.2 Select fields

In the new Self-Service dataset, add the "Signing Time" date field and the rest fields of the "FACT_SALE_CONTRACT" table. As shown in the following figure.

2.3 New column

Add "New column" to convert the "Signing Time" field to year/month format. The following figure shows.

2.4 Add formula

1）You can name a new column as  "year-month-day", enter the formula: REPLACE(LEFT(Signing Time,7), LEFT(Signing Time,5), LEFT(Signing Time,4)). Click "OK" to finish. As shown in the figure below.

Note: In the formula, you need to click on the "time field" under the corresponding field to enter, not through the rest of the way to enter.

The formula description is shown in the following table.

Note: The date format of 2020-02-02 or 2020/05/22 or 2020-02-02 00:00:00 can be converted using the above formula.

2）After adding the formula, name the Self-Service dataset and click "Save" to complete the date conversion. The effect is shown in the following figure.

3）The data can be viewed after "Update Data", as shown in the following figure.

3. Effect view

After converting the year-month-day hour-minute-second date format to year-month, the effect is shown in the following figure.