# DatePart (DateTime)

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

![](https://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/0%20\(106\).png)

**Example**

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

Where,

*dateTime* = 7/13/2022 4:12:19 PM

<figure><img src="https://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/1%20(107).png" alt=""><figcaption></figcaption></figure>

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

![](https://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/2%20\(107\).png)
