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