OBI for TEE - SQL Expression to schedule report of submissions created weekly

Content

Hi,

Hoping this will be an easy one!

I'm looking to schedule a report that runs weekly and tells me all the applications created within the prior week. I.e., the report is generated every Monday morning for applicants the prior week. What is the SQL expression I need to use on the Submission Created date?

Your responses are appreciated!