Purpose:

Converts a string to a date.

▪   If the string Contains a dot ".", it will be read in the "d.m.y" format (German).

▪   If the string contains a diagonal slash "/", it will be read in the "m/d/y" format (US English).

▪   If the string contains a dash "-", if will be read in the "y-m-d" format (ANSI).

▪   If the input cannot be correctly interpreted, then the date represents a value that is larger than all other values, (1e100). The return value can be evaluated for correctness using "JulianToDate(1e100)".

▪   When one or two digits represent the year, all values under 30 will be applied to the 21st century (20xx) and all values over 30 will be applied to the 20th century (19xx).

Parameter:

String

Return value:

Date

Example:

Date("17.10.2015")

Date("10/17/2015")

Date("2015-10-17")