DATE

Converts a value into value type “date”.

Syntax

DATE(value)

• value - the value which should be converted - Value type: text or number

Remarks

• For converting numbers to date, nedyx uses the 1900 date system, so a number represents the number of days since 01/01/1900.

Example

The left table contains the date values, which have been converted from the values in table1.