Hi,
You can use Xpath as below:
//ModuleName.Entity[DateRegistered > '[%BeginOfCurrentMonth%] - 1 * [%MonthLength%]' and //ModuleName.Entity[DateRegistered < '[%EndOfCurrentMonth%] - 1 * [%MonthLength%]
Hi,
For arithmatic operations, you can use ‘daysBetween’ function or 'trimToDays' function.
This returns a float value, so you can use round(), floor() functions depending on the requirements which will return integer value.
See Documentation : https://docs.mendix.com/refguide/between-date-function-calls
https://docs.mendix.com/refguide/trim-to-date#:~:text=5%20trimToDays%5BUTC%5D,uses%20the%20UTC%20time%20zone.