Number of input and output field

Number of input field	:	Two
Number of output field	:	One

This transformation function is used to calculate the difference between two dates (date₁ and date₂). The result is a double value representing the number of days between date₁ and date₂.

• If date₁ and date₂ are provided in timestamp format (milliseconds since midnight, January 1, 1970 UTC), the Diff function does not require any parameters.
• If the dates are not in timestamp format, the Diff function requires a date-format parameter, which is used to convert date₁ and date₂ into timestamp representations.
• If date₁ is earlier than date₂, the result will be a negative number.
• If date₁ is later than date₂, the result will be a positive number.