How to capture previous month dates

Here is a way of filtering previous month’s dates:

LET a_month_ago = addmonths(today(), -1)
[Date] >= monthstart(a_month_ago) AND [Date] <= monthend(a_month_ago)

Example:
previous-month.morph (2.5 KB)

1 Like