Check date field if it exists in previous month

[qlikwiz123]

I have a date field - Active DATE with values in MM/DD/YYYY format and ID

I need to create a set analysis expression where if the Active DATE is in Previous month and do a count on ID.

Let's say if an ID has Active DATE 4/25/2021, since it exists in previous month, I need to count that ID.

[jwjackso · Accepted solution]

{<[Active DATE]={">=$(=AddMonths(MonthStart(Today(1)),-1))<=$(=AddMonths(MonthEnd(Today(1)),-1))"}>}

[qlikwiz123]

@jwjackso  Great, thank you for the quick  help.