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
Page 1 / 1
This can be resolved via:
ROUND_DAY(table.timestamp_column) != ROUND_DAY(ADD_DAYS(TODAY(),-1))
ROUND_DAY(table.timestamp_column) != ROUND_DAY(ADD_DAYS(TODAY(),-1))
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.