Skip to main content
Topics#Reports & DashboardsLEAH Gus's Question
LEAH Gus (Gus) asked in #Reports & Dashboards
Oct 23, 2020, 12:29 PM

Report sorted by time

I need to run a report that shows all accounts that have activity on 8/8/2020 between midnight and 3 AM. How do I make a report that shows accounts with activity filtered by time.
5 answers
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    Oct 23, 2020, 1:49 PM
    Hi Leah,

     

    it's because it returns the time in GMT, so you need to offset it:

     

    HOUR(TIMEVALUE(CreatedDate))-4

     

    However, this won't work as the number 3 woudl give you anything between 3:00 and 3:59 AM.

     

    Change the return type of your formula to Time and change the formula to:

     

    TIMEVALUE(CreatedDate)-14400000

     

    Change your filters to:

     

    formula field greater or equal to 0:00:00.000 AND formula field less than or equal to 3:00:00.000 
Write an answer...
0/9000