What is the best way to retrieve data with dates from the last month in Mendix and compare them using XPath?

Question

I'm new to mendix and I ran into a problem comparing dates in mendix.

My task is to collect data whose date is one to the date of the last month.

e.g. date>=01.04.2023 && date<=30.04.2023

enter image description here

What is the easiest way to select the beginning of the last month and the end of the last month.

Thank in advance.

Answer 1

You probably want to be using the beginOfMonth function, depending on what you want (question is not 100% clear to me), in combination with addMonths.

See also here and here