Hello, I am needing assistance with a sql query that pulls current date and previous date data from 7 a.m. of the previous date to 7 a.m. of the current date. I understand how to hard code the information, but am needing to set this to run every day. The hard code of the date works, but doesn't change each day.
TestTable__1."CV_CA_Confirmed_Date_Time_Local" BETWEEN '2022-04-25 07:00:00' AND '2022-04-26 07:00:00'