# ToDate DateTime (DateTime)

| **Name**    | ***ToDate with Time***                                                                                                                                                                                                                                                        |
| ----------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Syntax      | ToDate (Integer year, Integer month, Integer day, Integer hour, Integer minute, Integer second)                                                                                                                                                                               |
| Purpose     | To create a new date using specified year, month, day, hour, minute, and second.                                                                                                                                                                                              |
| Description | Returns the newly created date if the parameters evaluate to a valid date. Otherwise returns null.                                                                                                                                                                            |
| Return Type | DateTime                                                                                                                                                                                                                                                                      |
| Parameters  | <p>year \[System.Int64] – Year including the century</p><p>month \[System.Int64] – Month (1-12)</p><p>day \[System.Int64] – Day (1-31)</p><p>hour \[System.Int64] – Hour (0-23)</p><p>minute \[System.Int64] – Minute (0-59)</p><p>second \[System.Int64] – Second (0-59)</p> |

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

**Example**

In this example, we will pass valid integer values to the function transformation object using a *Variables* object.

Where,

*year* = 2020

*month* = 01

*day* = 30

*hour* = 4

*minute* = 30

*second* = 10

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

In the output window, you can see that the provided values have been converted into a DateTime value.

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