DATEVALUE

Syntax:

DATEVALUE( text )

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

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

Example:

DATEVALUE("26.2.93 16:15")

returns the date value 26.02.1993 16:15:00.