> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# MakeDate

The **MakeDate** function evaluates specified values representing individual date (year, month, day) and time (hour, minute, second) components and returns a datetime value in ISO format.

## Syntax

```
MakeDate(year, month, day, [hour], [minute], [second])
```

Function arguments:

|            |                                                                      |
| :--------- | :------------------------------------------------------------------- |
| **year**   | (required) An integer representing the year.                         |
| **month**  | (required) An integer representing the month.                        |
| **day**    | (required) An integer representing the day of the month.             |
| **hour**   | (optional) An integer representing the hour (in the 24-hour format). |
| **minute** | (optional) An integer representing the minutes.                      |
| **second** | (optional) An integer representing the seconds.                      |

## Example

```
MakeDate(2019, 1, 31, 16, 30, 00)
```

Returns the datetime value `2019-01-31 16:30:00` (January 31, 2019 4:30 PM).

## Related resources

* [DateFromUnix](/docs/datefromunix)
* <a href="https://quickstarts.sigmacomputing.com/guide/common_date_functions/index.html" target="_blank" rel="noopener noreferrer">
    Quickstart: Common date functions and use cases
  </a>