How to capture previous month dates

1

Hello.
I have a list of date series from previous year till Today and I want to capture only previous months dates (in this case would be august 2022). Does EM have a formula similar to excel to use? Thanks.

2

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