DateDifference

This node finds difference between two dates

Input

It accepts a DataFrame as input from the previous Node

Type

transform

Fields

Name	Title	Description
fromDate	FromDate	From date column name
toDate	Todate	To date column name
useCurrentDateAsToDateCol	useCurrentDateAsToCol	Current Date As ToDate
days	Days	Days difference
hours	Hours	Hours difference
minutes	Minutes	Minutes difference
seconds	Seconds	Seconds difference

Details

Calculates difference between 2 given dates. Difference between dates is displayed in days, hours, minutes, and seconds columns.

Examples -------

Format Examples

dd-MM-yy : 30-11-95 to 19-02-18 diff- 8608 days : 206609 hours : 12396574 min : 743794461 : second dd-MM-yyyy : 10-02-1996 to 20-09-2017 diff- 8536 days : 204881 hours : 12292884 min : 737573070 : second MM-dd-yyyy : 19-10-1994 to 06-12-2017 diff- 9015 days : 216377 hours : 12982644 min : 778958670 : second yyyy-MM-dd : 1994-12-25 to 2019-01-16 diff- 8948 days : 214769 hours : 12886164 min : 773169870 : second yyyy-MM-dd HH:mm:ss : 2012-01-31 23:59:59 to 2010-12-30 22:59:59 diff-397 days: 1 hour: 0 minutes : 0 seconds

Input

id	date_string	date_string1
IntegerType	TimestampType	StringType
0	2011-1-1 00:00:00.0	05/26/2016 01:01:01
1	2012-1-14 01:00:00.0	06/22/2017 01:00:00
2	2013-12-10 02:00:00.0	01/12/2016 01:01:01

Parameters

Name	Value
FromDate	date_string
Todate
useCurrentDateAsToCol	true
Days	true
Hours	true
Minutes	true
Seconds	true

Output

id	date_string	date_string1	DateDiff	HoursDiff	MinutesDiff	SecondsDiff
0	2011-1-1 00:00:00.0	05/26/2016 01:01:01	3192	76615	4596911	275814696
1	2012-1-14 01:00:00.0	06/22/2017 01:00:00	2814	67542	4052531	243151896
2	2013-12-10 02:00:00.0	01/12/2016 01:01:01	2118	50837	3050231	183013896