>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.