Filter out yesterday

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))

1 Like