Question

Filter out yesterday

Forum|Forum|6 years ago
November 19, 2019
1 reply
26 views

paul.velth
Level 8

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

P

paul.velth
Author
Level 8
Forum|Forum|6 years ago
November 20, 2019

This can be resolved via: ROUND_DAY(table.timestamp_column) != ROUND_DAY(ADD_DAYS(TODAY(),-1))

Like

Sign up

Login with SSO

Login to the community

Login with SSO