DATEVALUE

From AgileApps Support Wiki

The DATEVALUE function creates a date from a datetime or text expression

Syntax
DATEVALUE('dString')
DATEVALUE('string')


The format must match the date format specified in the Company Information section. Day, month, and year are required; hour and minute are optional.

Return
Date
Examples
DATEVALUE('06/23/2010 1:27 pm') = 06/23/2010
DATEVALUE('06/23/2011') = 06/23/2011


See Date Format for more detail on the parameters used in this function.