Subscription query with dynamic dating

Hello,

I am trying to create a scheduled report that runs every morning and dynamically updates the date to the last 24 hour period. I've got the query running from "yesterday" at 0600 through "today" at 0559. Is the a way to set it so I don't need to manually update the date on the query?

I am running ServiceDesk Plus 11 build 11004 with MSSQL

SELECT "wo"."WORKORDERID" AS "Request ID", "aau"."FIRST_NAME" AS "Requester", "cd"."CATEGORYNAME" AS "Category", "scd"."NAME" AS "Subcategory", "wo"."TITLE" AS "Subject", "wotodesc"."FULLDESCRIPTION" AS "Description", "ti"."FIRST_NAME" AS "Technician", dateadd(s, datediff(s, GETUTCDATE(), getdate()) + (wo.createdtime/1000 [wo.createdtime]), '1970-01-01 00:00:00') AS "Created Time" FROM WorkOrder wo LEFT JOIN ModeDefinition mdd ON wo.MODEID = mdd.MODEID LEFT JOIN SDUser sdu ON wo.REQUESTERID = sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID = aau.USER_ID LEFT JOIN WorkOrderToDescription wotodesc ON wo.WORKORDERID = wotodesc.WORKORDERID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID = wos.WORKORDERID LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID = cd.CATEGORYID LEFT JOIN SubCategoryDefinition scd ON wos.SUBCATEGORYID = scd.SUBCATEGORYID LEFT JOIN SDUser td ON wos.OWNERID = td.USERID LEFT JOIN AaaUser ti ON td.USERID = ti.USER_ID WHERE (("mdd"."MODENAME" = 'Standby Call') AND (dateadd(s, datediff(s, GETUTCDATE(), getdate()) + (wo.createdtime / 1000), '1970-01-01 00:00:00') > = CONVERT(varchar, '2020-06-09 06:00:00', 21) AND dateadd(s, datediff(s, GETUTCDATE(), getdate()) + (wo.createdtime / 1000), '1970-01-01 00:00:00') <= CONVERT(varchar, '2020-06-10 5:59', 21)))