Skip to main content
Question

Filter out yesterday

  • November 19, 2019
  • 1 reply
  • 4 views
P
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

1 reply

P
Level 8
  • paul.velth
  • Author
  • Level 8
  • November 20, 2019
This can be resolved via: ROUND_DAY(table.timestamp_column) != ROUND_DAY(ADD_DAYS(TODAY(),-1))
Community Code of ConductAccessibility statement