DATEVALUE

Syntax:

DATEVALUE(text)

Converts the text string into a date value, and if further figures are included, a time value.

Example:

DATEVALUE("26.2.93 16:15")

returns the date value 26.02.1993 16:15:00.

Note that the text string must be in a recognisable Fireworkz date and time format, i.e. the figures in the date must be separated by full stops and the figures in the time by colons.