MakeDate

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|)

Returns: 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)

Returns the datetime value. Result: 2019-01-31 16:30:00

Last modified on March 13, 2026

LastDay Minute

Aggregate Functions

Date Functions

Logical Functions

Math Functions

Text Functions

Type Functions

Window Functions

Parameters

Validation

Examples

​Parameters

​Validation

​Examples

Parameters

Validation

Examples