Data Synchronisation StudioUser GuideCalculated ColumnsFunctionsHOUROn this pageHOUR Returns the hour of the day value (24 hour clock) of a DateTime. Syntax int? HOUR(DateTime? value) Example You can use it with a ModifiedDate column and the function would look like: HOUR(ModifiedDate) This would return the hour value of the modified date.