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

DateDifference

This node finds difference between two dates

Input

It accepts a DataFrame as input from the previous Node

Type

transform

Fields

NameTitleDescription
fromDateFromDateFrom date column name
toDateTodateTo date column name
useCurrentDateAsToDateColuseCurrentDateAsToColCurrent Date As ToDate
daysDaysDays difference
hoursHoursHours difference
minutesMinutesMinutes difference
secondsSecondsSeconds 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

iddate_stringdate_string1
IntegerTypeTimestampTypeStringType
02011-1-1 00:00:00.005/26/2016 01:01:01
12012-1-14 01:00:00.006/22/2017 01:00:00
22013-12-10 02:00:00.001/12/2016 01:01:01

Parameters

NameValue
FromDatedate_string
Todate
useCurrentDateAsToColtrue
Daystrue
Hourstrue
Minutestrue
Secondstrue

Output

iddate_stringdate_string1DateDiffHoursDiffMinutesDiffSecondsDiff
02011-1-1 00:00:00.005/26/2016 01:01:013192766154596911275814696
12012-1-14 01:00:00.006/22/2017 01:00:002814675424052531243151896
22013-12-10 02:00:00.001/12/2016 01:01:012118508373050231183013896