Evaluates specified year, month, day (and optional hour, minute, second) components and returns a datetime value in ISO format.
Category: date
Syntax:
MakeDate(year, month, day, |hour|, |minute|, |second|)
DateTimeColumn
Context Filtering: ✓ Yes
Parameters
| Name | Type | Required | Description |
|---|
year | number | ✓ Yes | An integer representing the year. |
month | number | ✓ Yes | An integer representing the month (1-12). |
day | number | ✓ Yes | An integer representing the day of the month (1-31). |
hour | number | ✗ No | An integer representing the hour (0-23). |
minute | number | ✗ No | An integer representing the minutes (0-59). |
second | number | ✗ No | An integer representing the seconds (0-59). |
Validation
- Minimum parameters: 3
- Maximum parameters: 6
Examples
MakeDate(2019, 1, 31, 16, 30, 0)
2019-01-31 16:30:00 Last modified on March 13, 2026
