DATEVALUE
From LongJump 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.