MAKEDATE(a,b)

MAKEDATE(a,b) is a date function that supplies a date value from a year and day value.

The expressions a and b (expression) in MAKEDATE must supply numeric values.
The following restrictions also apply: a>=0 (a represents a year value)
b>0 (b represents a day value)
Decimal places in a and b are truncated if necessary.

Result of the MAKEDATE(a,b) function

a or b is the NULL value

NULL value

a or b is the special NULL value

Error message

MAKEDATE(2004,49) in the INTERNAL date format outputs 2004-02-18