TIMEVALUE DAX Function (Date and Time)

Syntax  |  Return values  |  Remarks  |  Examples  |  Related  

Converts a time in text format to a time in datetime format.

Syntax

TIMEVALUE ( <TimeText> )

Parameter	Attributes	Description
TimeText		A text string that gives a time; date information in the string is ignored.

Return values

Scalar A single datetime value.

A time in datetime format.

Remarks

The TIMEVALUE function uses the locale and date/time settings of the client computer to understand the text value when performing the conversion.

» 1 related function

Examples

--  DATEVALUE/TIMEVALUE convert strings into dates and times
EVALUATE
{
    DATEVALUE ( "10/15/2020" ),
    DATEVALUE ( "10-15-2020" ),
    TIMEVALUE ( "12:45:01" ),
    TIMEVALUE ( "12.45.01 AM" ),
    TIMEVALUE ( "15:45:01 AM" )
}

Value
2020-10-15 00:00:00
2020-10-15 00:00:00
1899-12-30 12:45:01
1899-12-30 00:45:01
1899-12-30 15:45:01

Related functions

Other related functions are:

• DATEVALUE

Last update: Nov 14, 2024   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo, Imke Feldmann

Microsoft documentation: https://docs.microsoft.com/en-us/dax/timevalue-function-dax