Icon

DateTime_​Diff_​Excluding_​Specific_​Dates

DateTime_Diff_Excluding_Specific_Dates

DateTime_Diff_Excluding_Specific_Dates

A workflow illustrating how to calculate date&time differences while excluding specific dates from your calculation.

A workflow illustrating how to calculate date&time differences while excluding specific dates from yourcalculation. Date RangesExceptionsChecking if dateshould be excludedSumming thenumber of exceptionsNew column withthe correct date&time diff Table Creator Table Creator String to Date&Time Date&TimeDifference Rule Engine Table Row ToVariable Loop Start String to Date&Time Loop End GroupBy Column Expressions A workflow illustrating how to calculate date&time differences while excluding specific dates from yourcalculation. Date RangesExceptionsChecking if dateshould be excludedSumming thenumber of exceptionsNew column withthe correct date&time diffTable Creator Table Creator String to Date&Time Date&TimeDifference Rule Engine Table Row ToVariable Loop Start String to Date&Time Loop End GroupBy Column Expressions

Nodes

Extensions

Links