How do I get dates for this month up to yesterday?

[jamesnestler]

Knowledge Drop

Last tested: Nov 25, 2019
 

Create this in a table calc. It should result in yes/no values and you can filter out the nos.

trunc_months(${date_column}) = trunc_months(now()) AND extract_days(now()) > extract_days(${date_column})

This content is subject to limited support.