Skip to main content
We are trying to filter out yesterdays data. We know how to filter out today: FILTER ROUND_DAY(table.timestamp_column) != TODAY() Please let me know if anybody knows how to filter out yesterdays data. Best regards, Paul Velthuis
This can be resolved via: ROUND_DAY(table.timestamp_column) != ROUND_DAY(ADD_DAYS(TODAY(),-1))