DateDifferenceDays (DateTimeOffset)

Name	DateDifferenceDays with Offset
Syntax	DateDifferenceDays (DateTimeWithOffset leftDate, Date rightDate)
Purpose	To compute the difference between the specified dates in days.
Description	Subtracts a date time offset value from another date time value and returns result in days.
Return Type	Double
Parameters	leftDate [System.DateTimeOffset] – Date from which the other date will be subtracted rightDate [System.DateTime] – Date which will be subtracted

Example

In this example, we will pass date time values to be subtracted to the function transformation object using a Variables object.

Where,

leftDate = 01/03/2024

rightDate = 06/06/2022

In the output window, you can see that the provided date time offset, and date time values have been subtracted, and the output has been displayed in the form of days.