Skip to main content
info
This documentation is for version v2.3 of the product.
For the latest version(v2.7) documentation click here
Version: v2.3 print this page

DateToAge

This node converts a date-column into columns of age (both in years and in days).

Type

transform

Fields

NameTitleDescription
inputColNameInput Column NameInput Column Name
yearsOutputColNameYears Output Column NameNum Years Output Column Name
daysOutputColNameDays Output Column NameNum 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

transactionIdcardNumbertx_timestampamountmerchnatId
215667691-700032015-12-25 01:17:0614952.5943199-016
751006667-000122015-12-29 01:17:0616603.4463621-354
52339970-800012015-12-22 01:17:0629175.3564205-126
884800094-000032015-12-15 01:17:0630190.3150730-7993

Parameters

NameValue
Input Column Nametx_timestamp
Years Output Column Namenum_years
Days Output Column Namenum_days

Output

transactionIdcardNumbertx_timestampamountmerchnatIdnum_yearsnum_days
215667691-700032015-12-25 01:17:0614952.5943199-01631372
751006667-000122015-12-29 01:17:0616603.4463621-35431368
52339970-800012015-12-22 01:17:0629175.3564205-12631375
884800094-000032015-12-15 01:17:0630190.3150730-799331382