How to calculate and filter on last day of month (EOM)

Knowledge Drop

Last tested: June 2020

This can be done with custom filters:

extract_days(add_days(1,${date})) = 1

The logic is “tomorrow’s day of month is 1”. That is, the day after the last day of the month will always be the 1st of a month.