Salesforce formula:

Date/Time -> Hour

Problem you're solving: You have a Date/Time field and you need to see the hour

Tactical solution: Create a Formula field that returns a number with 0 decimal places, using the formula below (substituting 'DATETIME_FIELD' with the API name of the field you're referencing)

Example use cases:

'What time of day do we have the highest rate of call connects?'
'When are most of our cases created?'

Formula

IF(
AND(
DATEVALUE(DATETIME_FIELD) >= (DATE(YEAR(DATEVALUE(DATETIME_FIELD),3,1+7*2) - WEEKDAY(DATE(YEAR(DATEVALUE(DATETIME_FIELD)),3,7-0))), DATEVALUE(DATETIME_FIELD) <= (DATE(YEAR(DATEVALUE(DATETIME_FIELD)),11,1+7*1) - WEEKDAY(DATE(YEAR(DATEVALUE(DATETIME_FIELD)),11,8-0))) ),
FLOOR(((VALUE( MID( TEXT( DATETIME_FIELD - 0.16666667), 15, 2 ) ) - 0.16666667)/60)+(ROUND((VALUE( MID( TEXT( DATETIME_FIELD - 0.16666667), 12, 2 ) ) - 0.16666667),0))),
FLOOR( ((VALUE( MID( TEXT( DATETIME_FIELD - 0.20833333), 15, 2 ) ) - 0.20833333)/60)+(ROUND((VALUE( MID( TEXT( DATETIME_FIELD - 0.20833333), 12, 2 ) ) - 0.20833333),0))))

Google Sites

Report abuse