CREATEDATE

Returns a date, defined by year, month and day.

Syntax

CREATEDATE(year; month; day)

• year - the year of the returned date - Value type: number

• month - the month of the returned date - Value type: number

• day - the day of the returned date - Value type: number

Remarks

• nedyx uses the 1900 date system, meaning the first possible date is 1/1/1900.

• The three parameters allow the following values

  • year

    • if year is < 1900 or > 9999, !VALUE is returned

  • month

    • if month is < 1 or > 12, !VALUE is returned

  • day

    • day is always added as amount of days (-1) to the first day of the defined month, even if the resulting day is then in another month.

Examples