Date Difference¶

This node finds difference between two dates

Input¶

It accepts a DataFrame as input from the previous Node

transform

fire.nodes.etl.NodeDateDiff

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

Calculates the difference between two given date/datetime columns.

FROMDATE :- The input column (i.e from which date) is selected here and it should be of DateTimeStump datatype.
TODATE :- The input column (i.e upto which date) is selected here and it should be of DateTimeStump datatype.
USECURRENTDATEASTOCOL :- When set to true, uses current Date as the ‘TODATE’ value

Difference between the two date fields can be displayed in terms of days, hours, minutes and seconds.
To enable the new column(s) set the value of the field as true ( By Default, it is set to false )

Date Difference output when all fields are enabled as true.

dd-MM-yy : 30-11-95 to 19-02-18 diff- 8608 days : 206609 hours : 12396574 min : 743794461 : second

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