# 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://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/0%20\(105\).png)

**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://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/1%20(106).png" 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://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/2%20(106).png" alt=""><figcaption></figcaption></figure>