See the documentation here: https://world.mendix.com/display/refguide6/XPath+Keywords+and+System+Variables Example 3. In your case something like //Sales.Customer[DateRegistered > '[%BeginOfCurrentMonth%] - 1 * [%MonthLength%]' and //Sales.Customer[DateRegistered < '[%EndOfCurrentMonth%] - 1 * [%MonthLength%]
Regards,
Ronald
I would create 2 date variables which you can use to set the begin of the specified month and the end of the specified month.
I would create the first variable with addMonths([%BeginOfCurrentMonth%], -1) and the second date variable with AddSeconds([%BeginOfCurrentMonth%], -1). Then you can retrieve all objects with something like [ObjectX/Date >= $FirstDate and ObjectX/Date <= $LastDate)