Converts a date in the form of text to a date in datetime format.
A text string that represents a date.
A date in datetime format.
The DATEVALUE function uses the locale and date/time settings of the client computer to understand the text value when performing the conversion. If the current date/time settings represent dates in the format of Month/Day/Year, then the string, “1/8/2009”, would be converted to a datetime value equivalent to January 8th of 2009. However, if the current date and time settings represent dates in the format of Day/Month/Year, the same string would be converted as a datetime value equivalent to August 1st of 2009.
If the year portion of the DateText argument is omitted, the DATEVALUE function uses the current year from your computer’s built-in clock. Time information in the DateText argument is ignored.
Other related functions are:
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/datevalue-function-dax