Version: v2.3
DateToAge
This node converts a date-column into columns of age (both in years and in days).
Type
transform
Fields
Name | Title | Description |
---|---|---|
inputColName | Input Column Name | Input Column Name |
yearsOutputColName | Years Output Column Name | Num Years Output Column Name |
daysOutputColName | Days Output Column Name | Num Days Output Column Name |
Details
Calculates age from the given date or timestamp column. Age is calculated and displayed in years and days columns.
Examples -------
Examples when date is 06-25-2019 +++++++++++++++
dd-MM-yyyy : 20-09-2018 , 0 year : 278 days MM-dd-yyyy : 09-30-2018 , 0 year : 268 days yyyy-MM-dd : 2012-01-31 , 7 year : 2702 days
Examples
Input
transactionId | cardNumber | tx_timestamp | amount | merchnatId |
---|---|---|---|---|
215667691-7 | 0003 | 2015-12-25 01:17:06 | 14952.59 | 43199-016 |
751006667-0 | 0012 | 2015-12-29 01:17:06 | 16603.44 | 63621-354 |
52339970-8 | 0001 | 2015-12-22 01:17:06 | 29175.35 | 64205-126 |
884800094-0 | 0003 | 2015-12-15 01:17:06 | 30190.31 | 50730-7993 |
Parameters
Name | Value |
---|---|
Input Column Name | tx_timestamp |
Years Output Column Name | num_years |
Days Output Column Name | num_days |
Output
transactionId | cardNumber | tx_timestamp | amount | merchnatId | num_years | num_days |
---|---|---|---|---|---|---|
215667691-7 | 0003 | 2015-12-25 01:17:06 | 14952.59 | 43199-016 | 3 | 1372 |
751006667-0 | 0012 | 2015-12-29 01:17:06 | 16603.44 | 63621-354 | 3 | 1368 |
52339970-8 | 0001 | 2015-12-22 01:17:06 | 29175.35 | 64205-126 | 3 | 1375 |
884800094-0 | 0003 | 2015-12-15 01:17:06 | 30190.31 | 50730-7993 | 3 | 1382 |