Custom Date Format
Description
Converts the dates in a column to the user-required format.
Input
Data only
Output
Transformed Data
Configuration Fields
- Column name Takes a single column input for transformation.
- Date format User selects a specific format for the date conversion.
- Locale Specifies the language.
- Time zone Specifies the time zone.
- Output column New column for converted dates.
- Include original
- If true Includes the data rows from the previous activity with output column.
- If Disabled Gives only the output column.
Sample Input
| 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 |
| 5 | Ethan Carter | 05-May-2023 | 2023-05-10 | 1999.12.15 | 2024-11-01 |
| 6 | Fiona Green | 2023-06-20T08:00:00Z | 20-06-2023 | 1998/07/07 | 2023/12/31T23:59:59Z |
| 7 | George Hill | 2023.07.25 | 25th July 2023 | 1997-03-03 | 2024-10-20T09:30:00+00:00 |
| 8 | Hannah Lewis | 2023-08-15 | 08/15/2023 | 1996/11/11 | 2024-08-15T16:00:00+00:00 |
| 9 | Ian Moore | 15-09-2023 | 15th Sep 2023 | 1995-01-01 | 2025-07-01 |
| 10 | Jenny Owens | 2023/10/10 | October 10, 2023 | 1994.06.30 | 2026-03-15T10:45:00 |
Sample Configuration
Sample Output
| id | name | enrollmentDate | lastAccess | dob | graduationDate | Enrollment date new |
|---|---|---|---|---|---|---|
| 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 |
| 5 | Ethan Carter | 05-May-2023 | 2023-05-10 | 1999.12.15 | 2024-11-01 | 05/05/2023 |
| 6 | Fiona Green | 2023-06-20T08:00:00Z | 20-06-2023 | 1998/07/07 | 2023/12/31T23:59:59Z | 06/20/2023 |
| 7 | George Hill | 2023.07.25 | 25th July 2023 | 1997-03-03 | 2024-10-20T09:30:00+00:00 | 07/25/2023 |
| 8 | Hannah Lewis | 2023-08-15 | 08/15/2023 | 1996/11/11 | 2024-08-15T16:00:00+00:00 | 08/15/2023 |
| 9 | Ian Moore | 15-09-2023 | 15th Sep 2023 | 1995-01-01 | 2025-07-01 | 09/15/2023 |
| 10 | Jenny Owens | 2023/10/10 | October 10, 2023 | 1994.06.30 | 2026-03-15T10:45:00 | 10/10/2023 |