DATEVALUE
Returns date serial number corresponding to the provided date string.
Usage examples
-
DATEVALUE("1/1/2010") -
DATEVALUE(tableA.fieldB)
Syntax
DATEVALUE ( date_text )
-
date_text- the string representing the date.
Returns
number - the date in days given the date.