>>Sorry to jump in, but HOUR is not a valid SQL function.
>>
>>The DatePart function that Nicholas mentioned is how you can extract any single part (anything from hour to minute to day, etc) of a date.
>
>Yes, but I am still wondering about this DAX reference.
To be precise, HOUR() is not T-SQL function.
--sb--