```AND DATE(TIMESTAMP_SECONDS(CAST(CAST(last_opene...
# generaln
natewalck
03/03/2021, 9:54 PM Copy code
AND DATE(TIMESTAMP_SECONDS(CAST(CAST(last_opened_time AS FLOAT64) AS INT64))) >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 day)natewalck
03/03/2021, 9:54 PMAND DATE(TIMESTAMP_SECONDS(CAST(CAST(last_opened_time AS FLOAT64) AS INT64))) >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 day)