# DatePart (DateTimeOffset)

| **Name**    | ***DatePart with Offset***                                                                          |
| ----------- | --------------------------------------------------------------------------------------------------- |
| Syntax      | DatePart (DateTimeWithOffset dateTime)                                                              |
| Purpose     | To remove the time-offset part from the given date and returns date with time reset to 12:00:00 AM. |
| Description | Returns truncated date-time value after removing the given time-offset part.                        |
| Return Type | Date                                                                                                |
| Parameter   | dateTime \[System.DateTimeOffset] – date from which the time-offset part will be stripped           |

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

**Example**

In this example, we will pass a date-time offset value to the function transformation object using a *Variables* object.

Where,

*dateTime* = 01/03/2024 10:23:40 AM

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

In the output window, you can see that the provided date-time value has been returned with the time-offset part reset to 12:00:00 AM.

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