DATEVALUE Function (VisioShapeSheet)
Last modified: March 09, 2015
Applies to: Office 2013 | Visio 2013
In this article
Syntax
Remarks
Example 1
Example 2
Example 3
Example 4
Returns the date value represented by datetime or expression.
DATEVALUE("datetime"|expression[,lcid])
Parameters
|
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
|
datetime |
Required |
String |
Any string commonly recognized as a date and time or a reference to a cell containing a date and time. |
|
expression |
Required |
String |
Any expression that yields a date and time. |
|
lcid |
Optional |
Number |
Specifies the locale identifier to be used in evaluating a non-local datetime. The locale identifier is a number described in the system header files. |
Return Value
Datetime
Any time component in datetime or expression is discarded.
If datetime is missing or cannot be converted to a valid result, DATEVALUE returns a #VALUE! error.
The returned value is displayed using the short date style set by the system's current Regional Settings.
The DATEVALUE function also accepts a single number value for expression where the integer portion of the result represents the days since December 30, 1899.