Skip to content

ISDATETIME

Whether a value is a date, or a date and time.

Group: Information. Compatible with DAX.

Syntax

ISDATETIME ( <value> )

Parameter	Type	Description
`value`	Value	What is tested: a constant, a column in a row context, a measure or any expression.

Returns

Boolean. TRUE when the value is a date or a date and time, FALSE otherwise.

Remarks

A time from TIME is a date and time too (on 30 December 1899): TRUE.
A date's serial number, such as 46328, is a number, not a date. Text that reads like a date is text until DATEVALUE turns it into one.
ISNUMBER is TRUE for dates as well; ISDATETIME is the test that tells them apart from numbers.

Examples

Dates and look-alikes

EVALUATE
ROW (
    "DATE", ISDATETIME ( DATE ( 2026, 11, 2 ) ),
    "DATE + TIME", ISDATETIME ( DATE ( 2026, 11, 2 ) + TIME ( 14, 30, 0 ) ),
    "TIME", ISDATETIME ( TIME ( 8, 0, 0 ) ),
    "46328", ISDATETIME ( 46328 ),
    "Text", ISDATETIME ( "2026-11-02" ),
    "Blank", ISDATETIME ( BLANK () )
)

DATE	DATE + TIME	TIME	46328	Text	Blank
TRUE	TRUE	TRUE	FALSE	FALSE	FALSE

A column of the model

EVALUATE
ROW (
    "Maturity is a date", ISDATETIME ( MAX ( Holdings[Maturity] ) ),
    "and a number", ISNUMBER ( MAX ( Holdings[Maturity] ) ),
    "but not numeric", ISNUMERIC ( MAX ( Holdings[Maturity] ) )
)

Maturity is a date	and a number	but not numeric
TRUE	TRUE	FALSE

ISNUMBER, ISNUMERIC, DATEVALUE, DATE, ISSTRING.

Last updated 3 November 2026 · OpenBI Studio 0.3.74