function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
natty dreadnatty dread 

Filter Time on Report

I have a requirement to build a report showing only inbound calls received after 5PM for the last 6 months. With Salesforces lack of a time field I'm have a hard time figuring out how to filter for this. Any suggestions?

 

-Natty

Best Answer chosen by Admin (Salesforce Developers) 
natty dreadnatty dread

Took me longer than I'd like to admit but in case anyone else is wondering: 

 

1. Our call center app dumps a time stamp as text into the Activity Subject field, a formula will also accomplish this. 

2. Filter report where Subject contains 'PM' and '5:,6:,7:,8:,9:,10:,11:'.

3. Profit

 

-Natty