# Max (Date)

| **Name**    | ***Max (Date)***                                                                             |
| ----------- | -------------------------------------------------------------------------------------------- |
| Syntax      | Max (Date first, Date second)                                                                |
| Purpose     | To return the later of two date values.                                                      |
| Description | Returns the maximum of two date values.                                                      |
| Return Type | DateTime                                                                                     |
| Prameters   | <p>first \[System.DateTime] – First value</p><p>second \[System.DateTime] – Second value</p> |

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

**Example**

In this example, we are passing DateTime values to the function transformation object using a *Variables* object.

Where,

*first* = 09/08/1998

*second* = 05/04/1995

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

In the output window, you can see that the later date of the two provided date values has been returned.

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

Let’s now pass the same date values, but with different time values.

Where,

*first* = 09/08/1998 02:50:40 AM

*second* = 09/08/1998 02:50:50 AM

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

In the output window, you can see that the later datetime of the two provided datetime values has been returned.

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