Description
The Custom Date Format activity allows you to standardize or localize date values from a specific column by converting them into a desired format. This is especially useful when handling inconsistent date formats across systems or preparing data for reports and user-facing outputs.
You can define the output format, locale (for language and formatting conventions), and time zone to ensure the date is rendered exactly as needed for downstream processes or user regions. You can also choose to keep the original column or include only the formatted result.
Use case: Convert ISO dates or region-specific formats into a consistent MM/DD/YYYY format based on en-US locale for a dashboard export.
| Input Type | Required |
|---|
| Data | Required |
Output
| Output Type | Format | Description |
|---|
| Data | Tabular | Returns input data along with a new column containing the formatted date values. |
Configuration Fields
| Field Name | Required | Description |
|---|
| Column name | Yes | Specifies the column containing the date values to be transformed. Must contain recognizable date strings. |
| Date format | Yes | Defines the format in which the output date should be displayed (e.g., MM/DD/YYYY, DD-MM-YYYY). |
| Locale | Yes | Indicates the cultural formatting standard to apply (e.g., en-US, fr-FR, ja-JP). Affects month names, separators, etc. |
| Time zone | Yes | Determines the time zone context for interpreting the input dates (e.g., UTC, Asia/Kolkata). |
| Output column | Yes | The name of the new column that will store the formatted date values. |
| Include original | Yes | If true, keeps the original input data and appends the new column. If false, returns only the new output column. |
| id | name | enrollmentDate | lastAccess | dob | graduationDate |
|---|
| 1 | Alice Johnson | 2023-01-15 | 01/15/2023 | 2002-05-10T00:00:00 | 2026-05-15 |
| 2 | Bob Smith | 15-02-2023 | 15-Feb-2023 | 2003/04/12 | 2027-05-20 |
| 3 | Charlie Brown | 2023.03.10 | 10 Mar 2023 | 10-06-2001 | 2025-12-30T23:59:59 |
| 4 | Daisy Adams | 2023/04/01 | April 1, 2023 | 2000-09-21T12:30:00Z | 2024/06/15 |
Sample Configuration
| Field | Value |
|---|
| Column name | enrollmentDate |
| Date format | MM/DD/YYYY |
| Locale | en-US |
| Time zone | Asia/Kolkata |
| Output column | Enrollment_US |
| Include original | true |
Sample Output
| id | name | enrollmentDate | lastAccess | dob | graduationDate | Enrollment_US |
|---|
| 1 | Alice Johnson | 2023-01-15 | 01/15/2023 | 2002-05-10T00:00:00 | 2026-05-15 | 01/15/2023 |
| 2 | Bob Smith | 15-02-2023 | 15-Feb-2023 | 2003/04/12 | 2027-05-20 | 02/15/2023 |
| 3 | Charlie Brown | 2023.03.10 | 10 Mar 2023 | 10-06-2001 | 2025-12-30T23:59:59 | 03/10/2023 |
| 4 | Daisy Adams | 2023/04/01 | April 1, 2023 | 2000-09-21T12:30:00Z | 2024/06/15 | 04/01/2023 |
