Description
Returns the serial number of a date supplied as a text string.
Syntax
DATEVALUE ( date )
| Parameter | Description |
|---|---|
| date | A date in text format (specified as a text string or a source field containing a date) between January 1, 1900, and December 31, 9999. |
Remarks
If you omit the year, the current year is used.
Examples
The following function returns "41687":
DATEVALUE( "2/17/14")
The following example returns the serial number corresponding to the text-based date in source field S15.
DATEVALUE(S15)
If the field's value is 10/31/15, the function will return "42308".
See also