How to compare time stamp columns with logical operators

[ribs]

I have a time stamp column needs to be compared logically if it falls below or above certain time. when I use DAX fucntion, I get data type mismatch error as "DAX comparison operations do not support comparing values of type Date with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values"

The function is:

Query1[Del_Time] < "10:00"

Del_Time column is in Time datatype

[ribs]

Thank you, that worked!

[bhanu_gautam · Accepted solution]

@ribs 

You can use the TIME function to create a time value in DAX. Here is how you can modify your function:

Query1[Del_Time] < TIME(10, 0, 0)