AnsweredAssumed Answered

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

Question asked by xxx202xxx on Jul 27, 2017
Latest reply on Jul 28, 2017 by 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?

 

Outcomes