2 Replies Latest reply on Mar 29, 2013 7:57 AM by . Bld

    Filter to show yesterday and a section of the day that updates automatically

    . Bld

      So I'm trying to figure out how to make a calculation that takes a datetime field and shows me on a report things that happened yesterday from 5am to 8pm and updates each time I access it.  So today is Thurs and when I access today it shows me Weds info from 5am to 8pm and tomorrow if I accessed it, I would see Thurs info from 5am to 8pm.

       

      Secondary question: If possible I would like to also be able to make a filter that only shows me 5am to 8pm regardless of what day based on the datetime field.

       

      Any ideas?