Searching for data for the last month

[Zub]

Hi,

I'm a bit new to qlik and am building a report template. I have created a filter which has a search expression as follows:

= (DueDate >= Date('01/02/2024') AND DueDate <= Date('29/02/2024'))

Is there a way to make this dynamic so that I don't have to hardcode the previous month like above etc?

Thanks for any help!

[MatheusC]

see it like this

$(=(MonthStart(Date((Today(1))),-1) )) - '01/02/2024'
$(=(MonthEnd(Date((today(1))),-1))) - '29/02/2024'

Regarts, Matheus