# DateDifferenceDays (DateTime)

| **Name**    | ***DateDifferenceDays***                                                                                                                                  |
| ----------- | --------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Syntax      | DateDifferenceDays (Date leftDate, Date rightDate)                                                                                                        |
| Purpose     | To compute the difference between the specified dates in days.                                                                                            |
| Description | Subtracts a date time value from another date time value and returns result in days.                                                                      |
| Return Type | Double                                                                                                                                                    |
| Parameters  | <p>leftDate \[System.DateTime] – Date from which the other date will be subtracted</p><p>rightDate \[System.DateTime] – Date which will be subtracted</p> |

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FmBZvpX5jtrl5q1vGd61D%2F0.png?alt=media)

**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/01/2023

*rightDate* = 01/02/2022

<figure><img src="https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2Fy4CzSChanly940GLKSzj%2F1.png?alt=media" alt=""><figcaption></figcaption></figure>

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

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2Fkv08rPia1uO6rOyKDwwu%2F2.png?alt=media)
