Date

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 21^st century (20xx) and all values over 30 will be applied to the 20^th century (19xx).

Parameter:

String

Return value:

Date

Example:

Date("17.10.2007")
Date("10/17/2007")
Date("2007-10-17")