I have a dataset in bigquery with a TIMESTAMP column “register_date” (sample value “2017-11-19 22:45:05.000 UTC” ). I need to filter records based on x days or weeks before today criteria. Example query select all records which are 2 weeks old. Currently I have this query (which I feel like a kind of hack) that works and returns the correct