7 Replies Latest reply on Jul 28, 2017 5:05 AM by xxx202xxx

    ExecuteSQL - used to retrieve records for the last 24 hours.

    xxx202xxx

      I am looking for a where clause that can be used to retrieve records for the last 24 hours.  The query I am attempting to write covers a period of 0900 the previous day to 0859 the current day, Tuesday – Friday and 0900 Friday – 0859 Monday.   So I guess that is two querries. 

       

      Then as an additional question how would I add this to a report each for each day of the week located in the same space on the report?