Apex Code Development You need to sign in to do that
Don't have an account?
Mikeb66 Need formula for Hour Created & Hour Closed for a case
I want to be able to run a report based on the number of cases opened and closed per hour of the day, so I need to create a custom field that takes the Time/Date Opened field and converts it to just show the Hour created (24 hour time) and the same thing for the Time/Date Closed.
I've done this in the past at my last company, but don't remember the formula. Does anyone know how to do this?
The answer may be found here...
Calculating hour from CreatedDate
Please note, this solution does not take into account Daylight Savings