Skip to main content

Overview

The diff-dates transformation calculates the difference between two dates.

Syntax

diff-dates(<variable 1>, <variable 2>, unit="days")

Parameters

ParameterTypeRequiredDescription
variable 1dateYesFirst date
variable 2dateYesSecond date
unitstringNoUnit of difference: "milliseconds", "seconds", "minutes", "hours", "days", "months", or "years"
inputLocalestringNoLocale used to parse the input dates: "pt", "nl", "en", "de", "ja", "zh", or "fr"

Examples

diff-dates(<variable 1>, <variable 2>, unit="days")
diff-dates(<variable 1>, <variable 2>, unit="hours")
diff-dates(<variable 1>, <variable 2>, unit="seconds", inputLocale="fr")