>Michel, similar to what Naomi mentioned, HOUR is a function in DAX. DAX is the expression language for PowerPivot data models. (PowerPivot is used for "self-service" BI models created in Excel - the PowerPivot engine uses a subset of the SSAS Tabular technology)

Thanks

>You probably noticed that HOUR is color-coded in the SSMS, which adds to the confusion, as several functions documented in MSDN (but not related to SQL Server) wind up being color coded in SSMS. Maybe there is a way to modify the color coding, but I'm not sure.

Yes, highly confusing on that one.

>In any event, the DATEPART function is what you want to use in SQL Server.

Yes, that works very well.